AR_InvoiceHistoryHeader AR Invoice History Header Rel: 7.50 Bld: 408 6/29/2026 Physical Path: "MAS_"+%C$+"/AR"+%C$+"/AR_InvoiceHistoryHeader.M4T" SQL Create: Y SQL Sys DB: N SQL Null Dates: N Exclude V/I: N Create Tbl: N Bus Obj: AR_InvoiceHistoryInquiry_bus SO_SalesJournal_upd AR_SalesJournal_upd JC_JobBillingRegister_upd
KPRIMARY: InvoiceNo+HeaderSeqNo(**) **=Case Sensitive KCUSTOMER: ARDivisionNo(**)+CustomerNo+InvoiceNo+HeaderSeqNo(**) **=Case Sensitive KAPPSONO: ModuleCode+SalesOrderNo+InvoiceNo+HeaderSeqNo(**) **=Case Sensitive KBILLTONAME: ModuleCode+BillToName+InvoiceNo+HeaderSeqNo(**) **=Case Sensitive KAPPFROM: ModuleCode+InvoiceNo+HeaderSeqNo(**) **=Case Sensitive KCUSTPO: CustomerPONo+InvoiceNo+HeaderSeqNo(**) **=Case Sensitive KSHIPPING: ShippingInvoice+InvoiceNo+HeaderSeqNo(**) **=Case Sensitive KSALESORDER: SalesOrderNo+InvoiceNo+HeaderSeqNo(**) **=Case Sensitive KBILLTO: BillToName+InvoiceNo+HeaderSeqNo(**) **=Case Sensitive KINVOICEDATE: InvoiceDate(d)+InvoiceNo+HeaderSeqNo(**) **=Case Sensitive KDUPLICATEPO: ARDivisionNo(**)+CustomerNo+CustomerPONo+InvoiceNo+HeaderSeqNo(**) **=Case Sensitive KSHIPTOCODE: ShipToCode+InvoiceNo+HeaderSeqNo(**) **=Case Sensitive KSHIPTOZIP: ShipToZipCode+InvoiceNo+HeaderSeqNo(**) **=Case Sensitive KCOMMENT: Comment+InvoiceNo+HeaderSeqNo(**) **=Case Sensitive KBILLTOCUSTNO: BillToDivisionNo+BillToCustomerNo+InvoiceNo+HeaderSeqNo
Fld Column Name M/L TUR Description/Notes Class
1 InvoiceNo . . . . . . . . . . 20 SYY Invoice Number. . . . . . . . .INVOICE FmtType:MASTERNUMI 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 . . . . . . . ValGroup:ConsumerPII 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. . . . . . . . . 30 SNN Customer PO Number. . . . . . .CUSTOMERPONO Notes: {ARN$(89,15)} 15 ApplyToInvoiceNo. . . . . . . 20 SYN Apply To Invoice Number . . . .INVOICE FmtType:MASTERNUMI 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 . . . . . . . . . . . . 20 SNN Fax Number. . . . . . . . . . .TELEPHONENO ValGroup:ConsumerPII 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 MultipleSalesOrdersApplied. . 1 SYY Multiple Sales Orders Applied .YESNO DfltVal:N Valid:Y,N 28 MultipleCustomerPONos . . . . 1 SYY Multiple Customer Purchase OrdeYESNO DfltVal:N Valid:Y,N 29 MultipleDepositsApplied . . . 1 SYY Multiple Deposits Applied . . .YESNO DfltVal:N Valid:Y,N 30 OrderType . . . . . . . . . . 1 SYN Order Type. . . . . . . . . . . Valid:B,S,1 Notes: B=Backorde r, S=Standard, 1=One Step Invoice {ARN$(425,1)} 31 OrderDate . . . . . . . . . . 8 SNN Order Date. . . . . . . . . . .DATE Notes: {ARN$(426,6)} 32 BillToDivisionNo. . . . . . . 2 SNN Bill To Division Number . . . .ARDIVISION Mask:00 FmtType:ZEROFILL 33 BillToCustomerNo. . . . . . . 20 SYN Bill To Customer Number . . . .CUSTOMERNO FmtType:MASTERNUMC ChngTag:Re place1/BillToDivisionNo$ 34 BillToName. . . . . . . . . . 50 SNN Bill To Name. . . . . . . . . .NAME ValGroup:ConsumerPII Notes: {ARN$(36,30)} 35 BillToAddress1. . . . . . . . 40 SNN Bill To Address 1 . . . . . . .ADDRESSLINE ValGroup:ConsumerPII Notes: {ARN$(66,30)} 36 BillToAddress2. . . . . . . . 40 SNN Bill To Address 2 . . . . . . .ADDRESSLINE ValGroup:ConsumerPII Notes: {ARN$(96,30)} 37 BillToAddress3. . . . . . . . 40 SNN Bill To Address 3 . . . . . . .ADDRESSLINE ValGroup:ConsumerPII Notes: {ARN$(520,30)} 38 BillToCity. . . . . . . . . . 30 SNN Bill To City. . . . . . . . . .CITY ValGroup:ConsumerPII Notes: {ARN$(126,20)} 39 BillToState . . . . . . . . . 2 SYN Bill To State . . . . . . . . .STATE ValGroup:ConsumerPII Notes: {ARN$(146,2)} 40 BillToZipCode . . . . . . . . 10 SYN Bill To Zip Code. . . . . . . .ZIPCODE ValGroup:ConsumerPII Notes: {ARN$(148,10)} 41 BillToCountryCode . . . . . . 3 SYN Bill To Country Code. . . . . .COUNTRY ValGroup:ConsumerPII Notes: {ARN$(550,3)} 42 ShipToCode. . . . . . . . . . 4 SYN Ship-To Code. . . . . . . . . .SHIPTO Notes: {ARN$(158,4)} 43 ShipToName. . . . . . . . . . 50 SNN Ship To Name. . . . . . . . . .NAME ValGroup:ConsumerPII Notes: {ARN$(162,30)} 44 ShipToAddress1. . . . . . . . 40 SNN Ship To Address 1 . . . . . . .ADDRESSLINE ValGroup:ConsumerPII Notes: {ARN$(192,30)} 45 ShipToAddress2. . . . . . . . 40 SNN Ship To Address 2 . . . . . . .ADDRESSLINE ValGroup:ConsumerPII Notes: {ARN$(222,30)} 46 ShipToAddress3. . . . . . . . 40 SNN Ship To Address 3 . . . . . . .ADDRESSLINE ValGroup:ConsumerPII Notes: {ARN$(570,30)} 47 ShipToCity. . . . . . . . . . 30 SNN Ship To City. . . . . . . . . .CITY ValGroup:ConsumerPII Notes: {ARN$(252,20)} 48 ShipToState . . . . . . . . . 2 SYN Ship To State . . . . . . . . .STATE ValGroup:ConsumerPII Notes: {ARN$(272,2)} 49 ShipToZipCode . . . . . . . . 10 SYN Ship To Zip Code. . . . . . . .ZIPCODE ValGroup:ConsumerPII Notes: {ARN$(274,10)} 50 ShipToCountryCode . . . . . . 3 SYN Ship To Country Code. . . . . .COUNTRY ValGroup:ConsumerPII Notes: {ARN$(600,3)} 51 ShipDate. . . . . . . . . . . 8 SNN Ship To Date. . . . . . . . . .DATE Notes: {ARN$(284,6)} 52 ShipVia . . . . . . . . . . . 15 SYN Ship Via. . . . . . . . . . . .SHIPCODE Notes: {ARN$(74,15)} 53 ShipZone. . . . . . . . . . . 5 SYN Ship Zone . . . . . . . . . . .SHIPZONE Notes: Maintained {ARN$(432, 5)} 54 FOB . . . . . . . . . . . . . 15 SNN F.O.B.. . . . . . . . . . . . . Notes: {ARN$(320,15)} 55 ConfirmTo . . . . . . . . . . 50 SNN Confirm To. . . . . . . . . . .NAME ValGroup:ConsumerPII Notes: {ARN$(335,30)} 56 TelephoneNo . . . . . . . . . 20 SNN Telephone Number. . . . . . . .TELEPHONENO 57 TelephoneExt. . . . . . . . . 6 SNN Telephone Extension . . . . . .TELEPHONEEXT 58 TelephoneType . . . . . . . . 1 SYN Telephone Type. . . . . . . . . DfltVal:W Valid:W,C,H,O Notes: W=Work, C=Cell, H=Home, O=Other 59 CheckNoForDeposit . . . . . . 10 SNN Check Number For Deposit. . . .CHECKNO Mask:0000000000 FmtType:ZEROF ILL Notes: {ARN$(442,6)} 60 SplitCommissions. . . . . . . 1 SYY Split Commissions . . . . . . . DfltVal:N Valid:Y,N,O Notes: Y=Yes, N=No, O=Override {ARN$(467,1)} 61 SalespersonDivisionNo2. . . . 2 SNN Salesperson Division Number 2 .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {ARN$(468,2)} 62 SalespersonNo2. . . . . . . . 4 SYN Salesperson Number 2. . . . . .SALESPERSONNO FmtType:CHARNUM Notes: {ARN$(470,4)} 63 SalespersonDivisionNo3. . . . 2 SNN Salesperson Division Number 3 .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {ARN$(481,2)} 64 SalespersonNo3. . . . . . . . 4 SYN Salesperson Number 3. . . . . .SALESPERSONNO FmtType:CHARNUM Notes: {ARN$(483,4)} 65 SalespersonDivisionNo4. . . . 2 SNN Salesperson Division Number 4 .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {ARN$(494,2)} 66 SalespersonNo4. . . . . . . . 4 SYN Salesperson Number 4. . . . . .SALESPERSONNO FmtType:CHARNUM Notes: {ARN$(496,4)} 67 SalespersonDivisionNo5. . . . 2 SNN Salesperson Division Number 5 .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {ARN$(507,2)} 68 SalespersonNo5. . . . . . . . 4 SYN Salesperson Number 5. . . . . .SALESPERSONNO FmtType:CHARNUM Notes: {ARN$(509,4)} 69 PaymentType . . . . . . . . . 5 SYN Payment Type. . . . . . . . . .PAYMENTTYPE Notes: {ARN$(620,5)} 70 OtherPaymentTypeRefNo . . . . 24 SNN Other Payment Type Reference Nu Notes: {ARN$(625,24)} 71 PaymentTypeCategory . . . . . 1 SYN Payment Type Category . . . . . DfltVal:D Valid:P,D Notes: P=Payment, D=Deposit (SO1$(813,1) 72 RMANo . . . . . . . . . . . . 7 SYN RMA Number. . . . . . . . . . .RMANO FmtType:CHARNUM Notes: {ARN$(684,7)} 73 EBMSubmissionType . . . . . . 1 SYN EBM Submission Type . . . . . . Valid:M.A Notes: M=Manual, A=Auto {ARN$(553,1)} 74 EBMUserIDSubmittingThisOrder. 15 SYN EBM User ID Submitting This Ord Notes: {ARN$(554,15)} 75 EBMUserType . . . . . . . . . 1 SYN EBM User Type . . . . . . . . . Valid:1,2 Notes: 1=Business, 2=Consumer {ARN$(569,1)} 76 ShipperID . . . . . . . . . . 3 SYN ShipperID . . . . . . . . . . . Notes: {ARN$(851,3)} 77 UserKey . . . . . . . . . . . 10 SNN User Key. . . . . . . . . . . .USER Mask:0000000000 Notes: {ARN$(710,3)} 78 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM ChngTag:Repla ce0 Notes: {ARN$(858,3)} 79 ShipWeight. . . . . . . . . . 5 SYN Ship Weight . . . . . . . . . . Mask:00000 FmtType:CHARNUM Notes: {ARN$(437,5)} 80 ResidentialAddress. . . . . . 1 SYY Residential Address . . . . . .YESNO DfltVal:N Valid:Y,N 81 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . .EMAILADDRESS ValGroup:ConsumerPII 82 CRMUserID . . . . . . . . . . 11 SNN CRM User ID . . . . . . . . . . 83 CRMCompanyID. . . . . . . . . 11 SNN CRM Company ID. . . . . . . . . 84 CRMPersonID . . . . . . . . . 11 SNN CRM Person ID . . . . . . . . . 85 CRMOpportunityID. . . . . . . 11 SNN CRM Opportunity ID. . . . . . . 86 EInvoiceId. . . . . . . . . . 24 SNN eInvoice ID . . . . . . . . . . 87 SUTTransactionID. . . . . . . 32 SNN Sage Sales and Use Tax Transact 88 TaxableSalesAmt . . . . . . . 13.2 NNN Taxable Sales Amount. . . . . .AMOUNT Mask:###,###,###.00 Notes: {ARN[1]} 89 NonTaxableSalesAmt. . . . . . 13.2 NNN Non-Taxable Sales Amount. . . .AMOUNT Mask:###,###,###.00 Notes: {ARN[2]} 90 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {ARN[3]} 91 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {ARN[4]} 92 CostOfSalesAmt. . . . . . . . 13.2 NNN Cost Of Sales Amount. . . . . .AMOUNT Mask:###,###,###.00 Notes: {ARN[5]} 93 AmountSubjectToDiscount . . . 13.2 NNN Amount Subject to Discount. . .AMOUNT Mask:###,###,###.00 Notes: {ARN[0]} 94 DiscountRate. . . . . . . . . 9.3 NNN Discount Rate . . . . . . . . . Mask:###0.000 Notes: {ARN[2]} 95 DiscountAmt . . . . . . . . . 12.2 NNN Discount Amount . . . . . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {ARN[3]} 96 SalesSubjectToComm. . . . . . 13.2 NNN Sales Subject To Commission . .AMOUNT Mask:###,###,###.00 Notes: {ARN[6]} 97 CostSubjectToComm . . . . . . 13.2 NNN Cost Subject To Commission. . .AMOUNT Mask:###,###,###.00 Notes: {ARN[7]} 98 CommissionRate. . . . . . . . 9.3 NNN Commission Rate . . . . . . . .COMMISSIONRATE Mask:###0.000 Notes: {ARN[0]} 99 CommissionAmt . . . . . . . . 13.2 NNN Commission Amount . . . . . . .AMOUNT Mask:###,###,###.00 Notes: {ARN[8]} 100 SplitCommRate2. . . . . . . . 9.3 NNN Split Commission Rate 2 . . . .COMMISSIONRATE Mask:###0.000 Notes: {ARN$(474,7)} 101 SplitCommRate3. . . . . . . . 9.3 NNN Split Commission Rate 3 . . . .COMMISSIONRATE Mask:###0.000 Notes: {ARN$(487,7)} 102 SplitCommRate4. . . . . . . . 9.3 NNN Split Commission Rate 4 . . . .COMMISSIONRATE Mask:###0.000 Notes: {ARN$(500,7)} 103 SplitCommRate5. . . . . . . . 9.3 NNN Split Commission Rate 5 . . . .COMMISSIONRATE Mask:###0.000 Notes: {ARN$(513,7)} 104 DepositAmt. . . . . . . . . . 13.2 NNN Deposit Amount. . . . . . . . .AMOUNT Mask:###,###,###.00 Notes: {ARN[12]} 105 Weight. . . . . . . . . . . . 12.2 NNN Weight. . . . . . . . . . . . .AMOUNT Mask:##,###,###.00 Notes: {ARN[13]} 106 RetentionAmt. . . . . . . . . 13.2 NNN Retention Amount. . . . . . . .AMOUNT Mask:###,###,###.00 Notes: {ARN[9]} 107 NumberOfPackages. . . . . . . 5.0 NNN Number of Packages. . . . . . . Mask:###0 Notes: {ARN$(854, 4)} 108 EncryptedVals . . . . . . . . 1600 SNN PII Encrypted Values. . . . . . Read Only:Y 109 DateCreated . . . . . . . . . 8 SNN Date Created. . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 110 TimeCreated . . . . . . . . . 8 SNN Time Created. . . . . . . . . .TIME Read Only:Y 111 UserCreatedKey. . . . . . . . 10 SYN User Created Key. . . . . . . .USER Read Only:Y Mask:0000000000 112 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 113 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .TIME Read Only:Y 114 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL 115 FreightTaxCode. . . . . . . . 10 SYN Freight Tax Code. . . . . . . .SUTTAXCODE