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