AR_InvoiceHistoryHeader AR Invoice History Header Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AR_InvoiceHistoryInquiry_bus,SO_SalesJournal_upd,AR_SalesJournal_upd SQL Def: N SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_InvoiceHistoryHeader.M4T"
KPRIMARY: InvoiceNo+HeaderSeqNo KCUSTOMER: ARDivisionNo+CustomerNo+InvoiceNo+HeaderSeqNo KAPPSONO: ModuleCode+SalesOrderNo+InvoiceNo+HeaderSeqNo KBILLTONAME: ModuleCode+BillToName+InvoiceNo+HeaderSeqNo KAPPFROM: ModuleCode+InvoiceNo+HeaderSeqNo KCUSTPO: CustomerPONo+InvoiceNo+HeaderSeqNo KSHIPPING: ShippingInvoice+InvoiceNo+HeaderSeqNo KSALESORDER: SalesOrderNo+InvoiceNo+HeaderSeqNo KBILLTO: BillToName+InvoiceNo+HeaderSeqNo KINVOICEDATE: InvoiceDate(d)+InvoiceNo+HeaderSeqNo
Fld Column Name M/L TUR Description/Notes Class
1 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE FmtType:MASTERNUM Notes: {ARN$(1,7)} 2 HeaderSeqNo . . . . . . . . . 6 SNY Header Sequence Number. . . . . Mask:000000 FmtType:ZEROFILL Notes: {ARN$(8,3)} 3 ModuleCode. . . . . . . . . . 3 SYY Module Code . . . . . . . . . .MODULECODE Notes: AR, JC, SO {ARN$(11, 2)} 4 InvoiceType . . . . . . . . . 2 SYY 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 {ARN$(13,1)} 5 InvoiceDate . . . . . . . . . 8 SNY Invoice Date. . . . . . . . . .DATE Notes: {ARN$(14,6)} 6 TransactionDate . . . . . . . 8 SNN Transaction Date. . . . . . . .DATE Notes: {ARN$(170,6)} 7 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {ARN$(20,2)} 8 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO FmtType:MASTERNUMC Notes: {ARN$(22,7)} 9 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . .ARTERMS Mask:00 FmtType:ZEROFILL Notes: {ARN$(59,2)} 10 TaxSchedule . . . . . . . . . 9 SYN Tax Schedule. . . . . . . . . .TAXSCHEDULE FmtType:CHARNUM Notes: {ARN$(61,9)} 11 TaxExemptNo . . . . . . . . . 15 SNN Tax Exempt Number . . . . . . . Notes: {ARN$(410,15)} 12 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . .ARDIVISION Mask:00 FmtType:ZEROFILL 13 SalespersonNo . . . . . . . . 4 SYN Salesperson Number. . . . . . .SALESPERSONNO FmtType:CHARNUM Notes: {ARN$(70,4)} 14 CustomerPONo. . . . . . . . . 15 SNN Customer PO Number. . . . . . .CUSTOMERPONO Notes: {ARN$(89,15)} 15 ApplyToInvoiceNo. . . . . . . 7 SYN Apply To Invoice Number . . . . FmtType:CHARNUM Notes: (CM & DM) {ARN$(104,7)} 16 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .COMMENT30 Notes: {ARN$(111,30)} 17 RepetitiveInvoiceRefNo. . . . 4 SYN Repetitive Invoice Reference Nu FmtType:CHARNUM Notes: {ARN$(141,4)} 18 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO FmtType:CHARNUM Notes: {ARN$(145,7)} 19 InvoiceDueDate. . . . . . . . 8 SNN Invoice Due Date. . . . . . . .DATE Notes: {ARN$(152,6)} 20 DiscountDueDate . . . . . . . 8 SNN Discount Due Date . . . . . . .DATE Notes: {ARN$(158,6)} 21 SourceJournal . . . . . . . . 2 SNN Source Journal. . . . . . . . .SOURCEJOURNAL Notes: {ARN$(164,2)} 22 JournalNoGLBatchNo. . . . . . 6 SNN Journal Number/GL Batch Number. Mask:000000 FmtType:ZEROFILL Notes: {ARN$(166,4)} 23 BatchFax. . . . . . . . . . . 1 SYY Batch Fax . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {ARN$(713,1)} 24 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . .TELEPHONENO Notes: {ARN$(603,17)} 25 ShippingInvoice . . . . . . . 1 SYY Shipping Invoice. . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: Placeholder only in AR Record {ARN$(683,1)} 26 SalesOrderNo. . . . . . . . . 7 SYN Sales Order Number. . . . . . .SALESORDERNO FmtType:CHARNUM Notes: {ARN$(844,7)} 27 OrderType . . . . . . . . . . 1 SYN Order Type. . . . . . . . . . . Valid:B,S,1 Notes: B=Backorde r, S=Standard, 1=One Step Invoice {ARN$(425,1)} 28 OrderDate . . . . . . . . . . 8 SNN Order Date. . . . . . . . . . .DATE Notes: {ARN$(426,6)} 29 BillToName. . . . . . . . . . 30 SNN Bill To Name. . . . . . . . . .NAME Notes: {ARN$(36,30)} 30 BillToAddress1. . . . . . . . 30 SNN Bill To Address 1 . . . . . . .ADDRESSLINE Notes: {ARN$(66,30)} 31 BillToAddress2. . . . . . . . 30 SNN Bill To Address 2 . . . . . . .ADDRESSLINE Notes: {ARN$(96,30)} 32 BillToAddress3. . . . . . . . 30 SNN Bill To Address 3 . . . . . . .ADDRESSLINE Notes: {ARN$(520,30)} 33 BillToCity. . . . . . . . . . 20 SNN Bill To City. . . . . . . . . .CITY Notes: {ARN$(126,20)} 34 BillToState . . . . . . . . . 2 SYN Bill To State . . . . . . . . .STATE Notes: {ARN$(146,2)} 35 BillToZipCode . . . . . . . . 10 SYN Bill To Zip Code. . . . . . . .ZIPCODE Notes: {ARN$(148,10)} 36 BillToCountryCode . . . . . . 3 SYN Bill To Country Code. . . . . .COUNTRY Notes: {ARN$(550,3)} 37 ShipToCode. . . . . . . . . . 4 SYN Ship-To Code. . . . . . . . . .SHIPTO Notes: {ARN$(158,4)} 38 ShipToName. . . . . . . . . . 30 SNN Ship To Name. . . . . . . . . .NAME Notes: {ARN$(162,30)} 39 ShipToAddress1. . . . . . . . 30 SNN Ship To Address 1 . . . . . . .ADDRESSLINE Notes: {ARN$(192,30)} 40 ShipToAddress2. . . . . . . . 30 SNN Ship To Address 2 . . . . . . .ADDRESSLINE Notes: {ARN$(222,30)} 41 ShipToAddress3. . . . . . . . 30 SNN Ship To Address 3 . . . . . . .ADDRESSLINE Notes: {ARN$(570,30)} 42 ShipToCity. . . . . . . . . . 20 SNN Ship To City. . . . . . . . . .CITY Notes: {ARN$(252,20)} 43 ShipToState . . . . . . . . . 2 SYN Ship To State . . . . . . . . .STATE Notes: {ARN$(272,2)} 44 ShipToZipCode . . . . . . . . 10 SYN Ship To Zip Code. . . . . . . .ZIPCODE Notes: {ARN$(274,10)} 45 ShipToCountryCode . . . . . . 3 SYN Ship To Country Code. . . . . .COUNTRY Notes: {ARN$(600,3)} 46 ShipDate. . . . . . . . . . . 8 SNN Ship To Date. . . . . . . . . .DATE Notes: {ARN$(284,6)} 47 ShipVia . . . . . . . . . . . 15 SYN Ship Via. . . . . . . . . . . .SHIPCODE Notes: {ARN$(74,15)} 48 ShipZone. . . . . . . . . . . 5 SYN Ship Zone . . . . . . . . . . .SHIPZONE Notes: Maintained {ARN$(432, 5)} 49 FOB . . . . . . . . . . . . . 15 SNN F.O.B.. . . . . . . . . . . . . Notes: {ARN$(320,15)} 50 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . .NAME Notes: {ARN$(335,30)} 51 CheckNoForDeposit . . . . . . 7 SNN Check Number For Deposit. . . .CHECKNO Mask:0000000 FmtType:ZEROFILL Notes: {ARN$(442,6)} 52 SplitCommissions. . . . . . . 1 SYY Split Commissions . . . . . . . DfltVal:N Valid:Y,N,O Notes: Y=Yes, N=No, O=Override {ARN$(467,1)} 53 SalespersonDivisionNo2. . . . 2 SNN Salesperson Division Number 2 .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {ARN$(468,2)} 54 SalespersonNo2. . . . . . . . 4 SYN Salesperson Number 2. . . . . .SALESPERSONNO FmtType:CHARNUM Notes: {ARN$(470,4)} 55 SalespersonDivisionNo3. . . . 2 SNN Salesperson Division Number 3 .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {ARN$(481,2)} 56 SalespersonNo3. . . . . . . . 4 SYN Salesperson Number 3. . . . . .SALESPERSONNO FmtType:CHARNUM Notes: {ARN$(483,4)} 57 SalespersonDivisionNo4. . . . 2 SNN Salesperson Division Number 4 .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {ARN$(494,2)} 58 SalespersonNo4. . . . . . . . 4 SYN Salesperson Number 4. . . . . .SALESPERSONNO FmtType:CHARNUM Notes: {ARN$(496,4)} 59 SalespersonDivisionNo5. . . . 2 SNN Salesperson Division Number 5 .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {ARN$(507,2)} 60 SalespersonNo5. . . . . . . . 4 SYN Salesperson Number 5. . . . . .SALESPERSONNO FmtType:CHARNUM Notes: {ARN$(509,4)} 61 PaymentType . . . . . . . . . 5 SYN Payment Type. . . . . . . . . .PAYMENTTYPE Notes: {ARN$(620,5)} 62 PaymentTypeCategory . . . . . 1 SYN Payment Type Category . . . . . Notes: {ARN$(798,1)} 63 OtherPaymentTypeRefNo . . . . 24 SNN Other Payment Type Reference Nu Notes: {ARN$(625,24)} 64 CorporateCustIDPurchOrder . . 25 SNN Corporate Customer ID / Purchas 65 CorporateTaxOverrd. . . . . . 1 SYY Corporate Tax Overridden. . . .YESNO DfltVal:N Valid:Y,N 66 DepositCorporateTaxOverrd . . 1 SYY Deposit Corporate Tax OverriddeYESNO DfltVal:N Valid:Y,N 67 CardholderName. . . . . . . . 30 SNN Cardholder Name . . . . . . . .NAME Notes: {ARN$(649,30)} 68 ExpirationDateYear. . . . . . 4 SNN Expiration Date Year. . . . . .YEAR2 Notes: {ARN$(679,2)} 69 ExpirationDateMonth . . . . . 2 SNN Expiration Date Month . . . . .MONTH Mask:00 FmtType:ZEROFILL Notes: {ARN$(681,2)} 70 EncryptedCreditCardNo . . . . 24 SNN Encrypted Credit Card Number. .ENCRYPTEDCREDITCARDNO Notes: {ARN$(714,24)} 71 Last4UnencryptedCreditCardNos 4 SNN Last 4 Unencrypted Credit Card Notes: {ARN$(742,4)} 72 AuthorizationCode . . . . . . 16 SNN Authorization Code. . . . . . . Notes: {ARN$(746,16)} 73 AuthorizationCodeForDeposit . 16 SNN Authorization Code for Deposit. Notes: {ARN$(772,16)} 74 CreditCardTransactionID . . . 10 SNN Credit Card Transaction ID. . . Notes: {ARN$(762,10)} 75 CreditCardTransactionIDForDep 10 SNN Credit Card Transaction ID for Notes: {ARN$(788,10)} 76 RMANo . . . . . . . . . . . . 7 SYN RMA Number. . . . . . . . . . .RMANO FmtType:CHARNUM Notes: {ARN$(684,7)} 77 EBMSubmissionType . . . . . . 1 SYN EBM Submission Type . . . . . . Valid:M.A Notes: M=Manual, A=Auto {ARN$(553,1)} 78 EBMUserIDSubmittingThisOrder. 15 SYN EBM User ID Submitting This Ord Notes: {ARN$(554,15)} 79 EBMUserType . . . . . . . . . 1 SYN EBM User Type . . . . . . . . . Valid:1,2 Notes: 1=Business, 2=Consumer {ARN$(569,1)} 80 ShipperID . . . . . . . . . . 3 SYN ShipperID . . . . . . . . . . . Notes: {ARN$(851,3)} 81 UserKey . . . . . . . . . . . 10 SNN User Key. . . . . . . . . . . .USER Mask:0000000000 Notes: {ARN$(710,3)} 82 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM Notes: {ARN$(858,3)} 83 ShipWeight. . . . . . . . . . 5 SYN Ship Weight . . . . . . . . . . Mask:00000 FmtType:CHARNUM Notes: {ARN$(437,5)} 84 ResidentialAddress. . . . . . 1 SYY Residential Address . . . . . .YESNO DfltVal:N Valid:Y,N 85 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . .EMAILADDRESS 86 CRMUserID . . . . . . . . . . 11 SNN CRM User ID . . . . . . . . . . 87 CRMCompanyID. . . . . . . . . 11 SNN CRM Company ID. . . . . . . . . 88 CRMPersonID . . . . . . . . . 11 SNN CRM Person ID . . . . . . . . . 89 CRMOpportunityID. . . . . . . 11 SNN CRM Opportunity ID. . . . . . . 90 TaxableSalesAmt . . . . . . . 13.2 NNN Taxable Sales Amount. . . . . .AMOUNT Mask:###,###,###.00 Notes: {ARN[1]} 91 NonTaxableSalesAmt. . . . . . 13.2 NNN Non-Taxable Sales Amount. . . .AMOUNT Mask:###,###,###.00 Notes: {ARN[2]} 92 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {ARN[3]} 93 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {ARN[4]} 94 CostOfSalesAmt. . . . . . . . 13.2 NNN Cost Of Sales Amount. . . . . .AMOUNT Mask:###,###,###.00 Notes: {ARN[5]} 95 AmountSubjectToDiscount . . . 13.2 NNN Amount Subject to Discount. . .AMOUNT Mask:###,###,###.00 Notes: {ARN[0]} 96 DiscountRate. . . . . . . . . 9.3 NNN Discount Rate . . . . . . . . . Mask:###0.000 Notes: {ARN[2]} 97 DiscountAmt . . . . . . . . . 12.2 NNN Discount Amount . . . . . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {ARN[3]} 98 SalesSubjectToComm. . . . . . 13.2 NNN Sales Subject To Commission . .AMOUNT Mask:###,###,###.00 Notes: {ARN[6]} 99 CostSubjectToComm . . . . . . 13.2 NNN Cost Subject To Commission. . .AMOUNT Mask:###,###,###.00 Notes: {ARN[7]} 100 CommissionRate. . . . . . . . 9.3 NNN Commission Rate . . . . . . . .COMMISSIONRATE Mask:###0.000 Notes: {ARN[0]} 101 CommissionAmt . . . . . . . . 13.2 NNN Commission Amount . . . . . . .AMOUNT Mask:###,###,###.00 Notes: {ARN[8]} 102 SplitCommRate2. . . . . . . . 9.3 NNN Split Commission Rate 2 . . . .COMMISSIONRATE Mask:###0.000 Notes: {ARN$(474,7)} 103 SplitCommRate3. . . . . . . . 9.3 NNN Split Commission Rate 3 . . . .COMMISSIONRATE Mask:###0.000 Notes: {ARN$(487,7)} 104 SplitCommRate4. . . . . . . . 9.3 NNN Split Commission Rate 4 . . . .COMMISSIONRATE Mask:###0.000 Notes: {ARN$(500,7)} 105 SplitCommRate5. . . . . . . . 9.3 NNN Split Commission Rate 5 . . . .COMMISSIONRATE Mask:###0.000 Notes: {ARN$(513,7)} 106 DepositAmt. . . . . . . . . . 13.2 NNN Deposit Amount. . . . . . . . .AMOUNT Mask:###,###,###.00 Notes: {ARN[12]} 107 CreditCardPaymentBalanceAmt . 13.2 NNN Credit Card Payment / Balance AAMOUNT Mask:###,###,###.00 Notes: {ARN[14]} 108 Weight. . . . . . . . . . . . 12.2 NNN Weight. . . . . . . . . . . . .AMOUNT Mask:##,###,###.00 Notes: {ARN[13]} 109 RetentionAmt. . . . . . . . . 13.2 NNN Retention Amount. . . . . . . .AMOUNT Mask:###,###,###.00 Notes: {ARN[9]} 110 NumberOfPackages. . . . . . . 5.0 NNN Number of Packages. . . . . . . Mask:###0 Notes: {ARN$(854, 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 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 114 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y 115 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL