AR_InvoiceHistoryHeader AR Invoice History Header Rel: 6.00 Bld: 1024 3/10/2020 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 . . . . . . . . . . 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. . . . . . . . . 30 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 BillToDivisionNo. . . . . . . 2 SNN Bill To Division Number . . . .ARDIVISION Mask:00 FmtType:ZEROFILL 30 BillToCustomerNo. . . . . . . 20 SYN Bill To Customer Number . . . .CUSTOMERNO FmtType:MASTERNUMC ChngTag:Re place1/BillToDivisionNo$ 31 BillToName. . . . . . . . . . 30 SNN Bill To Name. . . . . . . . . .NAME Notes: {ARN$(36,30)} 32 BillToAddress1. . . . . . . . 30 SNN Bill To Address 1 . . . . . . .ADDRESSLINE Notes: {ARN$(66,30)} 33 BillToAddress2. . . . . . . . 30 SNN Bill To Address 2 . . . . . . .ADDRESSLINE Notes: {ARN$(96,30)} 34 BillToAddress3. . . . . . . . 30 SNN Bill To Address 3 . . . . . . .ADDRESSLINE Notes: {ARN$(520,30)} 35 BillToCity. . . . . . . . . . 20 SNN Bill To City. . . . . . . . . .CITY Notes: {ARN$(126,20)} 36 BillToState . . . . . . . . . 2 SYN Bill To State . . . . . . . . .STATE Notes: {ARN$(146,2)} 37 BillToZipCode . . . . . . . . 10 SYN Bill To Zip Code. . . . . . . .ZIPCODE Notes: {ARN$(148,10)} 38 BillToCountryCode . . . . . . 3 SYN Bill To Country Code. . . . . .COUNTRY Notes: {ARN$(550,3)} 39 ShipToCode. . . . . . . . . . 4 SYN Ship-To Code. . . . . . . . . .SHIPTO Notes: {ARN$(158,4)} 40 ShipToName. . . . . . . . . . 30 SNN Ship To Name. . . . . . . . . .NAME Notes: {ARN$(162,30)} 41 ShipToAddress1. . . . . . . . 30 SNN Ship To Address 1 . . . . . . .ADDRESSLINE Notes: {ARN$(192,30)} 42 ShipToAddress2. . . . . . . . 30 SNN Ship To Address 2 . . . . . . .ADDRESSLINE Notes: {ARN$(222,30)} 43 ShipToAddress3. . . . . . . . 30 SNN Ship To Address 3 . . . . . . .ADDRESSLINE Notes: {ARN$(570,30)} 44 ShipToCity. . . . . . . . . . 20 SNN Ship To City. . . . . . . . . .CITY Notes: {ARN$(252,20)} 45 ShipToState . . . . . . . . . 2 SYN Ship To State . . . . . . . . .STATE Notes: {ARN$(272,2)} 46 ShipToZipCode . . . . . . . . 10 SYN Ship To Zip Code. . . . . . . .ZIPCODE Notes: {ARN$(274,10)} 47 ShipToCountryCode . . . . . . 3 SYN Ship To Country Code. . . . . .COUNTRY Notes: {ARN$(600,3)} 48 ShipDate. . . . . . . . . . . 8 SNN Ship To Date. . . . . . . . . .DATE Notes: {ARN$(284,6)} 49 ShipVia . . . . . . . . . . . 15 SYN Ship Via. . . . . . . . . . . .SHIPCODE Notes: {ARN$(74,15)} 50 ShipZone. . . . . . . . . . . 5 SYN Ship Zone . . . . . . . . . . .SHIPZONE Notes: Maintained {ARN$(432, 5)} 51 FOB . . . . . . . . . . . . . 15 SNN F.O.B.. . . . . . . . . . . . . Notes: {ARN$(320,15)} 52 ConfirmTo . . . . . . . . . . 30 SNN Confirm To. . . . . . . . . . .NAME Notes: {ARN$(335,30)} 53 CheckNoForDeposit . . . . . . 10 SNN Check Number For Deposit. . . .CHECKNO Mask:0000000000 FmtType:ZEROF ILL Notes: {ARN$(442,6)} 54 SplitCommissions. . . . . . . 1 SYY Split Commissions . . . . . . . DfltVal:N Valid:Y,N,O Notes: Y=Yes, N=No, O=Override {ARN$(467,1)} 55 SalespersonDivisionNo2. . . . 2 SNN Salesperson Division Number 2 .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {ARN$(468,2)} 56 SalespersonNo2. . . . . . . . 4 SYN Salesperson Number 2. . . . . .SALESPERSONNO FmtType:CHARNUM Notes: {ARN$(470,4)} 57 SalespersonDivisionNo3. . . . 2 SNN Salesperson Division Number 3 .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {ARN$(481,2)} 58 SalespersonNo3. . . . . . . . 4 SYN Salesperson Number 3. . . . . .SALESPERSONNO FmtType:CHARNUM Notes: {ARN$(483,4)} 59 SalespersonDivisionNo4. . . . 2 SNN Salesperson Division Number 4 .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {ARN$(494,2)} 60 SalespersonNo4. . . . . . . . 4 SYN Salesperson Number 4. . . . . .SALESPERSONNO FmtType:CHARNUM Notes: {ARN$(496,4)} 61 SalespersonDivisionNo5. . . . 2 SNN Salesperson Division Number 5 .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {ARN$(507,2)} 62 SalespersonNo5. . . . . . . . 4 SYN Salesperson Number 5. . . . . .SALESPERSONNO FmtType:CHARNUM Notes: {ARN$(509,4)} 63 PaymentType . . . . . . . . . 5 SYN Payment Type. . . . . . . . . .PAYMENTTYPE Notes: {ARN$(620,5)} 64 OtherPaymentTypeRefNo . . . . 24 SNN Other Payment Type Reference Nu Notes: {ARN$(625,24)} 65 PaymentTypeCategory . . . . . 1 SYN Payment Type Category . . . . . DfltVal:D Valid:P,D Notes: P=Payment, D=Deposit (SO1$(813,1) 66 RMANo . . . . . . . . . . . . 7 SYN RMA Number. . . . . . . . . . .RMANO FmtType:CHARNUM Notes: {ARN$(684,7)} 67 EBMSubmissionType . . . . . . 1 SYN EBM Submission Type . . . . . . Valid:M.A Notes: M=Manual, A=Auto {ARN$(553,1)} 68 EBMUserIDSubmittingThisOrder. 15 SYN EBM User ID Submitting This Ord Notes: {ARN$(554,15)} 69 EBMUserType . . . . . . . . . 1 SYN EBM User Type . . . . . . . . . Valid:1,2 Notes: 1=Business, 2=Consumer {ARN$(569,1)} 70 ShipperID . . . . . . . . . . 3 SYN ShipperID . . . . . . . . . . . Notes: {ARN$(851,3)} 71 UserKey . . . . . . . . . . . 10 SNN User Key. . . . . . . . . . . .USER Mask:0000000000 Notes: {ARN$(710,3)} 72 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE FmtType:CHARNUM Notes: {ARN$(858,3)} 73 ShipWeight. . . . . . . . . . 5 SYN Ship Weight . . . . . . . . . . Mask:00000 FmtType:CHARNUM Notes: {ARN$(437,5)} 74 ResidentialAddress. . . . . . 1 SYY Residential Address . . . . . .YESNO DfltVal:N Valid:Y,N 75 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . .EMAILADDRESS 76 CRMUserID . . . . . . . . . . 11 SNN CRM User ID . . . . . . . . . . 77 CRMCompanyID. . . . . . . . . 11 SNN CRM Company ID. . . . . . . . . 78 CRMPersonID . . . . . . . . . 11 SNN CRM Person ID . . . . . . . . . 79 CRMOpportunityID. . . . . . . 11 SNN CRM Opportunity ID. . . . . . . 80 TaxableSalesAmt . . . . . . . 13.2 NNN Taxable Sales Amount. . . . . .AMOUNT Mask:###,###,###.00 Notes: {ARN[1]} 81 NonTaxableSalesAmt. . . . . . 13.2 NNN Non-Taxable Sales Amount. . . .AMOUNT Mask:###,###,###.00 Notes: {ARN[2]} 82 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {ARN[3]} 83 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {ARN[4]} 84 CostOfSalesAmt. . . . . . . . 13.2 NNN Cost Of Sales Amount. . . . . .AMOUNT Mask:###,###,###.00 Notes: {ARN[5]} 85 AmountSubjectToDiscount . . . 13.2 NNN Amount Subject to Discount. . .AMOUNT Mask:###,###,###.00 Notes: {ARN[0]} 86 DiscountRate. . . . . . . . . 9.3 NNN Discount Rate . . . . . . . . . Mask:###0.000 Notes: {ARN[2]} 87 DiscountAmt . . . . . . . . . 12.2 NNN Discount Amount . . . . . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {ARN[3]} 88 SalesSubjectToComm. . . . . . 13.2 NNN Sales Subject To Commission . .AMOUNT Mask:###,###,###.00 Notes: {ARN[6]} 89 CostSubjectToComm . . . . . . 13.2 NNN Cost Subject To Commission. . .AMOUNT Mask:###,###,###.00 Notes: {ARN[7]} 90 CommissionRate. . . . . . . . 9.3 NNN Commission Rate . . . . . . . .COMMISSIONRATE Mask:###0.000 Notes: {ARN[0]} 91 CommissionAmt . . . . . . . . 13.2 NNN Commission Amount . . . . . . .AMOUNT Mask:###,###,###.00 Notes: {ARN[8]} 92 SplitCommRate2. . . . . . . . 9.3 NNN Split Commission Rate 2 . . . .COMMISSIONRATE Mask:###0.000 Notes: {ARN$(474,7)} 93 SplitCommRate3. . . . . . . . 9.3 NNN Split Commission Rate 3 . . . .COMMISSIONRATE Mask:###0.000 Notes: {ARN$(487,7)} 94 SplitCommRate4. . . . . . . . 9.3 NNN Split Commission Rate 4 . . . .COMMISSIONRATE Mask:###0.000 Notes: {ARN$(500,7)} 95 SplitCommRate5. . . . . . . . 9.3 NNN Split Commission Rate 5 . . . .COMMISSIONRATE Mask:###0.000 Notes: {ARN$(513,7)} 96 DepositAmt. . . . . . . . . . 13.2 NNN Deposit Amount. . . . . . . . .AMOUNT Mask:###,###,###.00 Notes: {ARN[12]} 97 Weight. . . . . . . . . . . . 12.2 NNN Weight. . . . . . . . . . . . .AMOUNT Mask:##,###,###.00 Notes: {ARN[13]} 98 RetentionAmt. . . . . . . . . 13.2 NNN Retention Amount. . . . . . . .AMOUNT Mask:###,###,###.00 Notes: {ARN[9]} 99 NumberOfPackages. . . . . . . 5.0 NNN Number of Packages. . . . . . . Mask:###0 Notes: {ARN$(854, 4)} 100 DateCreated . . . . . . . . . 8 SNN Date Created. . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 101 TimeCreated . . . . . . . . . 8 SNN Time Created. . . . . . . . . .TIME Read Only:Y 102 UserCreatedKey. . . . . . . . 10 SYN User Created Key. . . . . . . .USER Read Only:Y Mask:0000000000 103 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 104 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .TIME Read Only:Y 105 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL 106 MultipleSalesOrdersApplied. . 1 SYY Multiple Sales Orders Applied .YESNO DfltVal:N Valid:Y,N 107 MultipleCustomerPONos . . . . 1 SYY Multiple Customer Purchase OrdeYESNO DfltVal:N Valid:Y,N 108 MultipleDepositsApplied . . . 1 SYY Multiple Deposits Applied . . .YESNO DfltVal:N Valid:Y,N