AR_TransactionPosting AR Transaction Posting Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AR_SalesJournal_upd,SO_SalesJournal_upd,AR_CommissionEditRegister_upd
SQL Def: N SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_TransactionPosting.M4T"
KPRIMARY: InvoiceNo
KBATCH: BatchNo+InvoiceNo
Fld Column Name M/L TUR Description/Notes Class
1 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE
FmtType:MASTERNUM Notes:
{SO5$(1,7)}
2 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE
Notes: {SO5$(8,6)}
3 InvoiceType . . . . . . . . . 2 SYN Invoice Type. . . . . . . . . .
Valid:CM,DM,IN,AD,FC,CA,XD
Notes: CM=Credit Memo,
DM=Debit Memo, IN=Invoice,
AD=Adjustment., FC=Finance
Charge, CA=Cash, XD=Deleted
{SO5$(14,1)}
4 SalesOrderNo. . . . . . . . . 7 SYN Sales Order Number. . . . . . .SALESORDERNO
FmtType:CHARNUM DepVal:REQUIR
ED Notes: {SO5$(15,7)}
5 OrderType . . . . . . . . . . 1 SYN Order Type. . . . . . . . . . .
Valid:B,S,1 Notes: B=Backorde
r, S=Standard,1=One Step
{SO5$(428,1)}
6 OrderDate . . . . . . . . . . 8 SNN Order Date. . . . . . . . . . .DATE
Notes: {SO5$(430,6)}
7 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION
Mask:00 FmtType:ZEROFILL
DepVal:REQUIRED Notes:
{SO5$(22,2)}
8 CustomerNo. . . . . . . . . . 20 SYN Customer Number . . . . . . . .CUSTOMERNO
FmtType:MASTERNUMC DepVal:REQ
UIRED Notes: {SO5$(24,7)}
9 BillToName. . . . . . . . . . 30 SNN Bill-To Name. . . . . . . . . .NAME
ValGroup:CustomerRequired
Notes: {SO5$(31,30)}
10 BillToAddress1. . . . . . . . 30 SNN Bill-To Address 1 . . . . . . .ADDRESSLINE
ValGroup:CustomerRequired
Notes: {SO5$(61,30)}
11 BillToAddress2. . . . . . . . 30 SNN Bill-To Address 2 . . . . . . .ADDRESSLINE
ValGroup:CustomerRequired
Notes: {SO5$(91,30)}
12 BillToAddress3. . . . . . . . 30 SNN Bill-To Address 3 . . . . . . .ADDRESSLINE
ValGroup:CustomerRequired
Notes: {SO5$(558,30)}
13 BillToCity. . . . . . . . . . 20 SNN Bill-To City. . . . . . . . . .CITY
ValGroup:CustomerRequired
Notes: {SO5$(121,20)}
14 BillToState . . . . . . . . . 2 SYN Bill-To State . . . . . . . . .STATE
ValGroup:CustomerRequired
Notes: {SO5$(141,2)}
15 BillToZipCode . . . . . . . . 10 SYN Bill-To Zip Code. . . . . . . .ZIPCODE
ValGroup:CustomerRequired
Notes: {SO5$(143,10)}
16 BillToCountryCode . . . . . . 3 SYN Bill-To Country Code. . . . . .COUNTRY
ValGroup:CustomerRequired
Notes: {SO5$(588,3)}
17 ShipToCode. . . . . . . . . . 4 SYN Ship-To Code. . . . . . . . . .SHIPTO
ValGroup:CustomerRequired
Notes: {SO5$(153,4)}
18 ShipToName. . . . . . . . . . 30 SNN Ship-To Name. . . . . . . . . .NAME
ValGroup:CustomerRequired
Notes: {SO5$(157,30)}
19 ShipToAddress1. . . . . . . . 30 SNN Ship-To Address 1 . . . . . . .ADDRESSLINE
ValGroup:CustomerRequired
Notes: {SO5$(187,30)}
20 ShipToAddress2. . . . . . . . 30 SNN Ship-To Address 2 . . . . . . .ADDRESSLINE
ValGroup:CustomerRequired
Notes: {SO5$(217,30)}
21 ShipToAddress3. . . . . . . . 30 SNN Ship-To Address 3 . . . . . . .ADDRESSLINE
ValGroup:CustomerRequired
Notes: {SO5$(608,30)}
22 ShipToCity. . . . . . . . . . 20 SNN Ship-To City. . . . . . . . . .CITY
ValGroup:CustomerRequired
Notes: {SO5$(247,20)}
23 ShipToState . . . . . . . . . 2 SYN Ship-To State . . . . . . . . .STATE
ValGroup:CustomerRequired
Notes: {SO5$(267,2)}
24 ShipToZipCode . . . . . . . . 10 SYN Ship-To Zip Code. . . . . . . .ZIPCODE
ValGroup:CustomerRequired
Notes: {SO5$(269,10)}
25 ShipToCountryCode . . . . . . 3 SYN Ship-To Country Code. . . . . .COUNTRY
ValGroup:CustomerRequired
Notes: {SO5$(638,3)}
26 ShipDate. . . . . . . . . . . 8 SNN Ship Date . . . . . . . . . . .DATE
ValGroup:CustomerRequired
Notes: {SO5$(280,6)}
27 ShipVia . . . . . . . . . . . 15 SYN Ship Via. . . . . . . . . . . .SHIPCODE
ValGroup:CustomerRequired
Notes: {SO5$(301,15)}
28 ShipZone. . . . . . . . . . . 5 SYN Ship Zone . . . . . . . . . . .SHIPZONE
ValGroup:CustomerRequired
Notes: (Maintained)
{SO5$(444,5)}
29 ShipWeight. . . . . . . . . . 5 SYN Ship Weight . . . . . . . . . .
Mask:00000 FmtType:CHARNUM
ValGroup:CustomerRequired
Notes: {SO5$(449,5)}
30 CustomerPONo. . . . . . . . . 15 SNN Customer PO Number. . . . . . .CUSTOMERPONO
ValGroup:CustomerRequired
Notes: {SO5$(286,15)}
31 FOB . . . . . . . . . . . . . 15 SNN F.O.B.. . . . . . . . . . . . .
ValGroup:CustomerRequired
Notes: {SO5$(316,15)}
32 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE
FmtType:CHARNUM ValGroup:Mult
iWarehouse Notes: {SO5$(331,
3)}
33 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . .
ValGroup:CustomerRequired
Notes: {SO5$(334,30)}
34 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .COMMENT30
Notes: {SO5$(364,30)}
35 TaxSchedule . . . . . . . . . 9 SYN Tax Schedule. . . . . . . . . .TAXSCHEDULE
FmtType:CHARNUM ValGroup:Cust
omerRequired,ARSalesTax
Notes: {SO5$(394,9)}
36 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . .ARTERMS
Mask:00 FmtType:ZEROFILL
ValGroup:CustomerRequired
Notes: {SO5$(403,2)}
37 TaxExemptNo . . . . . . . . . 15 SNN Tax Exempt Number . . . . . . .
ValGroup:CustomerRequired,
ARSalesTax Notes: (Only If
Sales Tax Reporting = Yes)
{SO5$(409,15)}
38 CustomerType. . . . . . . . . 4 SYN Customer Type . . . . . . . . .
ValGroup:CustomerRequired
Notes: (From Update)
{SO5$(436,4)}
39 CheckNoForDeposit . . . . . . 10 SNN Check Number For Deposit. . . .CHECKNO
FmtType:ZEROFILL Notes:
{SO5$(464,6)}
40 ApplyToInvoiceNo. . . . . . . 7 SYN Apply To Invoice Number . . . .
FmtType:CHARNUM ValGroup:Cust
omerRequired Notes: (For CM
& Dm Types) {SO5$(470,7)}
41 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . .ARDIVISION
Mask:00 FmtType:ZEROFILL
ValGroup:CustomerRequired,
SalespersonReporting
42 SalespersonNo . . . . . . . . 4 SYN Salesperson Number. . . . . . .SALESPERSONNO
FmtType:CHARNUM ValGroup:Sale
spersonReporting Notes:
{SO5$(405,4)}
43 SplitCommissions. . . . . . . 1 SYN Split Commissions . . . . . . .
Valid:Y,N,O ValGroup:SplitCom
mission,SalespersonRequired
Notes: Y=Yes, N=No,
O=Override {SO5$(478,1)}
44 SalespersonDivisionNo2. . . . 2 SNN Salesperson Division Number 2 .ARDIVISION
Mask:00 FmtType:ZEROFILL
ValGroup:SplitCommission,
SalespersonRequired Notes:
{SO5$(479,2)}
45 SalespersonNo2. . . . . . . . 4 SYN Salesperson Number 2. . . . . .SALESPERSONNO
FmtType:CHARNUM DepVal:Requir
ed ValGroup:SplitCommission,
SalespersonRequired Notes:
{SO5$(481,4)}
46 SalespersonDivisionNo3. . . . 2 SNN Salesperson Division Number 3 .ARDIVISION
Mask:00 FmtType:ZEROFILL
ValGroup:SplitCommission,
SalespersonRequired Notes:
{SO5$(492,2)}
47 SalespersonNo3. . . . . . . . 4 SYN Salesperson Number 3. . . . . .SALESPERSONNO
FmtType:CHARNUM DepVal:Requir
ed ValGroup:SplitCommission,
SalespersonRequired Notes:
{SO5$(494,4)}
48 SalespersonDivisionNo4. . . . 2 SNN Salesperson Division Number 4 .ARDIVISION
Mask:00 FmtType:ZEROFILL
ValGroup:SplitCommission,
SalespersonRequired Notes:
{SO5$(505,2)}
49 SalespersonNo4. . . . . . . . 4 SYN Salesperson Number 4. . . . . .SALESPERSONNO
FmtType:CHARNUM DepVal:Requir
ed ValGroup:SplitCommission,
SalespersonRequired Notes:
{SO5$(507,4)}
50 SalespersonDivisionNo5. . . . 2 SNN Salesperson Division Number 5 .ARDIVISION
Mask:00 FmtType:ZEROFILL
ValGroup:SplitCommission,
SalespersonRequired Notes:
{SO5$(518,2)}
51 SalespersonNo5. . . . . . . . 4 SYN Salesperson Number 5. . . . . .SALESPERSONNO
FmtType:CHARNUM DepVal:Requir
ed ValGroup:SplitCommission,
SalespersonRequired Notes:
{SO5$(520,4)}
52 InvoiceDueDate. . . . . . . . 8 SNN Invoice Due Date. . . . . . . .DATE
Notes: {SO5$(531,6)}
53 DiscountDueDate . . . . . . . 8 SNN Discount Due Date . . . . . . .DATE
Notes: {SO5$(537,6)}
54 BatchNo . . . . . . . . . . . 5 SYN Batch Number. . . . . . . . . .BATCHNO
FmtType:ALPHANUM Notes:
{SO5$(553,5)}
55 EBMSubmissionType . . . . . . 1 SYN e-Business Manager Submission T
Read Only:Y Valid:M,A Notes:
M=Manual, A=Auto {SO5$(591,
1)}
56 EBMUserIDSubmittingThisOrder. 15 SYN e-Business Manager User ID Subm
Read Only:Y Notes: {SO5$(592,
15)}
57 EBMUserType . . . . . . . . . 1 SYN e-Business Manager User Type. .
Read Only:Y Valid:1,2 Notes:
1=bus., 2=consumer {SO5$(443,
1)}
58 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . .TELEPHONENO
Notes: {SO5$(641,17)}
59 BatchFax. . . . . . . . . . . 1 SYN Batch Fax . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{SO5$(441,1)}
60 PaymentType . . . . . . . . . 5 SYN Payment Type. . . . . . . . . .PAYMENTTYPE
Notes: {SO5$(658,5)}
61 PaymentTypeCategory . . . . . 1 SYN Payment Type Category . . . . .
Valid:P,D Notes: P=Payment,
D=Deposit {SO5$(836,1)}
62 OtherPaymentTypeRefNo . . . . 24 SNN Other Payment Type Reference Nu
Notes: {SO5$(663,24)}
63 CorporateCustIDPurchOrder . . 25 SNN Corporate Customer ID Purchase
64 CorporateTaxOverrd. . . . . . 1 SYN Corporate Tax Override. . . . .YESNO
DfltVal:N Valid:Y,N
65 DepositCorporateTaxOverrd . . 1 SYN Deposit Corporate Tax Override.YESNO
DfltVal:N Valid:Y,N
66 CardholderName. . . . . . . . 30 SNN Cardholder Name . . . . . . . .NAME
Notes: {SO5$(687,30)}
67 ExpirationDateYear. . . . . . 4 SNN Expiration Date Year. . . . . .YEAR2
Notes: {SO5$(717,2)}
68 ExpirationDateMonth . . . . . 2 SNN Expiration Date Month . . . . .MONTH
Mask:00 FmtType:ZEROFILL
Notes: {SO5$(719,2)}
69 EncryptedCreditCardNo . . . . 24 SNN Encrypted Credit Card Number. .ENCRYPTEDCREDITCARDNO
Notes: {SO5$(739,24)}
70 Last4UnencryptedCreditCardNos 4 SNN Last 4 Unencrypted Credit Card
Notes: {SO5$(767,4)}
71 CreditCardAuthorizationNo . . 16 SNN Credit Card Authorization Numbe
Notes: {SO5$(771,16)}
72 AuthorizationCodeForDeposit . 16 SNN Authorization Code For Deposit.
DepVal:REQUIRED Notes:
{SO5$(810,16)}
73 CreditCardTransactionID . . . 10 SNN Credit Card Transaction ID. . .
Notes: {SO5$(787,10)}
74 CreditCardTransactionIDForDep 10 SNN Credit Card Transaction ID for
Notes: {SO5$(826,10)}
75 ShipperID . . . . . . . . . . 3 SYN Shipper ID. . . . . . . . . . .
Notes: {SO5$(848,3)}
76 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO
FmtType:CHARNUM ValGroup:JCIn
tegrated
77 RMANo . . . . . . . . . . . . 7 SYN RMA Number. . . . . . . . . . .RMANO
FmtType:CHARNUM Notes:
{SO5$(721,7)}
78 Adjustment. . . . . . . . . . 1 SYN Adjustment Valid. . . . . . . .YESNO
DfltVal:N Valid:Y,N
79 RepetitiveInvoiceRefNo. . . . 4 SNN Repetitive Invoice Reference Nu
80 ResidentialAddress. . . . . . 1 SYY Residential Address . . . . . .YESNO
DfltVal:N Valid:Y,N
81 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . .EMAILADDRESS
82 CRMCompanyID. . . . . . . . . 11 SNN CRM Company ID. . . . . . . . .
83 CRMOpportunityID. . . . . . . 11 SNN CRM Opportunity ID. . . . . . .
84 CRMUserID . . . . . . . . . . 11 SNN CRM User ID . . . . . . . . . .
85 CRMPersonID . . . . . . . . . 11 SNN CRM Person ID . . . . . . . . .
86 TaxableSubjectToDiscount. . . 13.2 NNN Taxable Subject To Discount . .AMOUNT
Mask:###,###,###.00 Notes:
{SO5[1]}
87 NonTaxableSubjectToDiscount . 13.2 NNN Non-Taxable Subject To DiscountAMOUNT
Mask:###,###,###.00 Notes:
{SO5[2]}
88 TaxSubjToDiscPrcntOfTotSubjTo 8.2 NNN Tax SubjectTo Disc % Of Total S
Mask:#,###.00- Notes:
{SO5[3]}
89 DiscountRate. . . . . . . . . 9.3 NNN Discount Rate . . . . . . . . .
Mask:#,###.000 ValGroup:Custo
merRequired Notes: {SO5[4]}
90 TaxableAmt. . . . . . . . . . 13.2 NNN Taxable Amount. . . . . . . . .AMOUNT
Mask:###,###,###.00
ValGroup:CustomerRequired
Notes: {SO5[6]}
91 NonTaxableAmt . . . . . . . . 13.2 NNN Non-Taxable Amount. . . . . . .AMOUNT
Mask:###,###,###.00
ValGroup:CustomerRequired
Notes: {SO5[7]}
92 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . .MISCAMOUNT
Mask:##,###,###.00-
ValGroup:CustomerRequired,
ARSalesTax Notes: {SO5[8]}
93 DiscountAmt . . . . . . . . . 12.2 NNN Discount Amount . . . . . . . .MISCAMOUNT
Mask:##,###,###.00-
ValGroup:CustomerRequired
Notes: {SO5[5]}
94 RetentionAmt. . . . . . . . . 13.2 NNN Retention Amount. . . . . . . .
Mask:###,###,###.00
95 TotalSubjectToComm. . . . . . 13.2 NNN Total Subject To Commission . .AMOUNT
Mask:###,###,###.00
ValGroup:CustomerRequired
Notes: (Calc @ Pre-Update)
{SO5[9]}
96 CommissionRate. . . . . . . . 9.3 NNN Commission Rate . . . . . . . .COMMISSIONRATE
Mask:###0.000 ValGroup:Custom
erRequired,SalespersonReporti
ng,SalespersonRequired
Notes: {SO5[10]}
97 CommissionAmt . . . . . . . . 12.2 NNN Commission Amount . . . . . . .MISCAMOUNT
Mask:##,###,###.00- Notes:
(Calc @ Pre-Update) {SO5[11]}
98 SplitCommRate2. . . . . . . . 9.3 NNN Split Commission Rate 2 . . . .
Mask:###0.000 ValGroup:SplitC
ommission,SalespersonRequired
Notes: {SO5$(485,7)}
99 SplitCommRate3. . . . . . . . 9.3 NNN Split Commission Rate 3 . . . .
Mask:###0.000 ValGroup:SplitC
ommission,SalespersonRequired
Notes: {SO5$(498,7)}
100 SplitCommRate4. . . . . . . . 9.3 NNN Split Commission Rate 4 . . . .
Mask:###0.000 ValGroup:SplitC
ommission,SalespersonRequired
Notes: {SO5$(511,7)}
101 SplitCommRate5. . . . . . . . 9.3 NNN Split Commission Rate 5 . . . .
Mask:###0.000 ValGroup:SplitC
ommission,SalespersonRequired
Notes: {SO5$(524,7)}
102 OverrideCommAmt . . . . . . . 12.2 NNN Override Commissn Amount. . . .
Mask:##,###,###.00- Notes:
{SO5$(543,10)}
103 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . .
Mask:##,###,###.00- Notes:
{SO5[12]}
104 CostOfGoodsSoldAmt. . . . . . 13.2 NNN Cost Of Goods Sold Amount. . .
Mask:###,###,###.00- Notes:
(Calc @ Pre-Update) {SO5[13]}
105 CostOfGoodsSoldSubjToComm . . 13.2 NNN Cost of Goods Sold Subject To C
Mask:###,###,###.00- Notes:
Calc @ Pre-Update) {SO5[14]}
106 DepositAmt. . . . . . . . . . 13.2 NNN Deposit Amount. . . . . . . . .
Mask:###,###,###.00- Notes:
{SO5[15]}
107 Weight. . . . . . . . . . . . 12.2 NNN Weight. . . . . . . . . . . . .
Mask:##,###,###.00- Notes:
{SO5[16]}
108 CreditCardPreAuthorizationAmt 13.2 NNN Credit Card Pre-Authorization A
Mask:###,###,###.00- Notes:
{SO5[17]}
109 CreditCardPaymentBalanceAmt . 13.2 NNN Credit Card Payment / Balance A
Mask:###,###,###.00- Notes:
{SO5[18]}
110 NumberofPackages. . . . . . . 4.0 NNN Number of Packages. . . . . . .
Mask:0000 Notes: {SO5$(853,
4)}
111 DepositCorporateSalesTax. . . 12.2 NNN Deposit Corporate Sales Tax . .MISCAMOUNT
Mask:##,###,###.00-
112 CorporateSalesTax . . . . . . 12.2 NNN Corporate Sales Tax . . . . . .MISCAMOUNT
Mask:##,###,###.00-
113 UserCreatedKey. . . . . . . . 10 SYY User Created Key. . . . . . . .USER
Read Only:Y Mask:0000000000
114 UserUpdatedKey. . . . . . . . 10 SNN User. . . . . . . . . . . . . .USER
Read Only:Y Mask:0000000000