AR_InvoiceHeader AR Invoice Header Rel: 6.00 Bld: 1024 3/10/2020 Physical Path: "MAS_"+%C$+"/AR"+%C$+"/AR_InvoiceHeader.M4T" SQL Create: Y SQL Sys DB: N SQL Null Dates: N Exclude V/I: N Create Tbl: N Bus Obj: AR_Invoice_bus
KPRIMARY: InvoiceNo+InvoiceType KBATCH: BatchNo+InvoiceNo+InvoiceType KCUSTOMER: ARDivisionNo+CustomerNo+InvoiceNo+InvoiceType KDUPLICATEPO: ARDivisionNo+CustomerNo+CustomerPONo+InvoiceNo+InvoiceType KBILLTOCUSTNO: BillToDivisionNo+BillToCustomerNo+InvoiceNo+InvoiceType KCREDITCARDGUID: CreditCardGUID+InvoiceNo+InvoiceType KPAYMENTTYPE: PaymentType+InvoiceNo+InvoiceType
Fld Column Name M/L TUR Description/Notes Class
1 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE FmtType:MASTERNUMC Next:Invoi ceNo$ Notes: {AR7$(1,7)} 2 InvoiceType . . . . . . . . . 2 SYY Invoice Type. . . . . . . . . . DfltVal:IN Valid:CM,DM,IN,FC, CA,XD Notes: CM=Credit Memo, DM=Debit Memo, IN=INvoice, FC=Finance Charge, CA=CAsh, XD=Deleted {AR7$(8,2)} 3 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION Mask:00 FmtType:ZEROFILL ValGroup:ARDivisionRequired Notes: {AR7$(10,2)} 4 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO FmtType:MASTERNUMC ChngTag:Re place1/ARDivisionNo$ Notes: {AR7$(12,7)} 5 SoldTo. . . . . . . . . . . . 30 SNN Sold To . . . . . . . . . . . .NAME Notes: {AR7$(19,30)} 6 BillToDivisionNo. . . . . . . 2 SNN Bill To Division Number . . . .ARDIVISION Mask:00 FmtType:ZEROFILL ValGroup:BillToCustomerRpting ,ARDivisionRequired 7 BillToCustomerNo. . . . . . . 20 SYN Bill To Customer Number . . . .CUSTOMERNO FmtType:MASTERNUMC DepVal:REQ UIRED ValGroup:BillToCustomer Rpting 8 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE DepVal:REQUIRED Notes: {AR7$(49,6)} 9 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . .ARTERMS Mask:00 FmtType:ZEROFILL DepVal:REQUIRED Notes: {AR7$(55,2)} 10 TaxSchedule . . . . . . . . . 9 SYN Tax Schedule. . . . . . . . . .TAXSCHEDULE FmtType:CHARNUM DepVal:REQUIR ED ValGroup:ARSalesTax Notes: {AR7$(57,9)} 11 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . .ARDIVISION Mask:00 FmtType:ZEROFILL ValGroup:ARDivisionRequired, SalespersonReporting, CustomerRequired 12 SalespersonNo . . . . . . . . 4 SYN Salesperson Number. . . . . . .SALESPERSONNO FmtType:CHARNUM DepVal:REQUIR ED ValGroup:SalespersonReport ing,CustomerRequired Notes: {AR7$(66,4)} 13 PrintInvoice. . . . . . . . . 1 SYN Print Invoice . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {AR7$(70,1)} 14 ShipMethod. . . . . . . . . . 15 SYN Ship Method . . . . . . . . . .SHIPCODE Notes: {AR7$(71,15)} 15 CustomerPONo. . . . . . . . . 30 SNN Customer PO Number. . . . . . .CUSTOMERPONO Notes: {AR7$(86,15)} 16 ApplyToInvoiceNo. . . . . . . 7 SYN Apply To Invoice Number . . . . FmtType:CHARNUM DepVal:REQUIR ED Notes: {AR7$(101,7)} 17 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .COMMENT30 Notes: {AR7$(108,30)} 18 Adjustment. . . . . . . . . . 1 SYN Adjustment. . . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {AR7$(138,1)} 19 RepetitiveInvoiceRefNo. . . . 4 SYN Repetitive Invoice Reference Nu FmtType:CHARNUM Notes: {AR7$(139,4)} 20 ActuallyPrinted . . . . . . . 1 SYN Actually Printed. . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {AR7$(143,1)} 21 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO FmtType:CHARNUM DepVal:REQUIR ED ValGroup:JCIntegrated Notes: {AR7$(144,7)} 22 InvoiceDueDate. . . . . . . . 8 SNN Invoice Due Date. . . . . . . .DATE Notes: {AR7$(151,6)} 23 DiscountDueDate . . . . . . . 8 SNN Discount Due Date . . . . . . .DATE Notes: {AR7$(157,6)} 24 BatchNo . . . . . . . . . . . 5 SYN Batch Number. . . . . . . . . .BATCHNO FmtType:ALPHANUM Notes: {AR7$(163,5)} 25 InvalidTaxCalc. . . . . . . . 1 SYN Invalid Tax Calculation . . . .YESNO DfltVal:N Valid:Y,N ValGroup:ARSalesTax Notes: {AR7$(168,1)} 26 BatchFax. . . . . . . . . . . 1 SYN Batch Fax . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {AR7$(169,1)} 27 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . .TELEPHONENO Notes: {AR7$(170,17)} 28 EmailAddress. . . . . . . . . 250 SNN Email Address . . . . . . . . .EMAILADDRESS 29 PaymentType . . . . . . . . . 5 SNN Payment Type. . . . . . . . . .PAYMENTTYPE DepVal:REQUIRED 30 CreditCardID. . . . . . . . . 10 SNN Credit Card / ACH Payment ID. .CREDITCARDID DepVal:REQUIRED 31 CreditCardGUID. . . . . . . . 32 SNN Sage Exchange Vault Payment IdeCREDITCARDGUID DepVal:REQUIRED ValGroup:Paym ent 32 CardType. . . . . . . . . . . 1 SNN Credit Card Type. . . . . . . . Valid:2,3,4,5,6,7,D,O ValGroup:CreditCard Notes: 2=MasterCard, 3=AMEX, 4=Visa, 5=MasterCard, 6=Discover, 7=JCB, D=Debit Card, O=Other 33 Last4UnencryptedCreditCardNos 4 SNN Last 4 Unencrypted Credit Card FmtType:ZEROFILL ValGroup:Cre ditCard 34 Last4BankRoutingNos . . . . . 4 SNN Last 4 Routing Numbers. . . . . Read Only:Y FmtType:ZEROFILL ValGroup:ACH 35 Last4BankAccountNos . . . . . 4 SNN Last 4 Bank Account Numbers . . Read Only:Y FmtType:ZEROFILL ValGroup:ACH 36 BankName. . . . . . . . . . . 30 SNN Bank Name . . . . . . . . . . .NAME ValGroup:ACH 37 BankAccountType . . . . . . . 1 SYN Bank Account Type . . . . . . . Read Only:Y DfltVal:C Valid:C,S ValGroup:ACH 38 ExpirationDateYear. . . . . . 4 SNN Expiration Date Year. . . . . . ValGroup:CreditCard 39 ExpirationDateMonth . . . . . 2 SNN Expiration Date Month . . . . .FISCALPERIOD Mask:00 FmtType:ZEROFILL ValGroup:CreditCard 40 CorporateCustIDPurchOrder . . 17 SNN Corporate Customer ID / Purchas DepVal:REQUIRED ValGroup:Cred itCard 41 CorporateTaxOverrd. . . . . . 1 SYN Corporate Tax Overridden. . . .YESNO DfltVal:N Valid:Y,N ValGroup:CreditCard 42 CardholderName. . . . . . . . 30 SNN Cardholder / Account Name . . . ValGroup:Payment 43 CreditCardTrackingID. . . . . 36 SNN Payment Tracking ID . . . . . . ValGroup:Payment 44 CreditCardTransactionID . . . 10 SNN Payment Transaction ID. . . . . DepVal:REQUIRED ValGroup:Paym ent ValSeqNo:9999 45 CreditCardAuthorizationNo . . 16 SNN Payment Authorization Number. . DepVal:REQUIRED ValGroup:Paym ent ValSeqNo:9999 46 AuthorizationDate . . . . . . 8 SNN Authorization Date. . . . . . .DATE ValGroup:Payment 47 AuthorizationTime . . . . . . 8 SNN Authorization Time. . . . . . .TIME ValGroup:Payment 48 AVSAddressLine1 . . . . . . . 30 SNN AVS Address Line 1. . . . . . .ADDRESSLINE ValGroup:Payment 49 AVSAddressLine2 . . . . . . . 30 SNN AVS Address Line 2. . . . . . .ADDRESSLINE ValGroup:Payment 50 AVSCity . . . . . . . . . . . 20 SNN AVS City. . . . . . . . . . . .CITY ValGroup:Payment 51 AVSState. . . . . . . . . . . 2 SYN AVS State . . . . . . . . . . .STATE ValGroup:Payment 52 AVSZipCode. . . . . . . . . . 10 SYN AVS Zip Code. . . . . . . . . .ZIPCODE ValGroup:Payment 53 AVSCountryCode. . . . . . . . 3 SNN AVS Country Code. . . . . . . .COUNTRY ValGroup:Payment 54 CreditCardEmailAddress. . . . 250 SNN Payment Email Address . . . . .EMAILADDRESS ValGroup:Payment 55 CreditCardComment . . . . . . 30 SNN Payment Comment . . . . . . . . ValGroup:Payment 56 SaveCreditCard. . . . . . . . 1 SYY Save / Update Payment InformatiYESNO DfltVal:N Valid:Y,N ValGroup:Payment 57 CommissionRate. . . . . . . . 9.3 NNN Commission Rate . . . . . . . .COMMISSIONRATE Mask:###0.000 ValGroup:Salesp ersonReporting Notes: {AR7[0]} 58 TaxableSalesAmt . . . . . . . 14.2 NNN Taxable Sales Amount. . . . . .SALESAMOUNT Read Only:Y Mask:#,###,###, ###.00- ValGroup:ARSalesTax Notes: {AR7[1]} 59 NonTaxableSalesAmt. . . . . . 14.2 NNN Non Taxable Sales Amount. . . .SALESAMOUNT Read Only:Y Mask:#,###,###, ###.00- Notes: {AR7[2]} 60 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . .MISCAMOUNT Mask:##,###,###.00- ValSeqNo:9999 Notes: {AR7[3]} 61 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . .MISCAMOUNT Read Only:Y Mask:##,###, ###.00- ValGroup:ARSalesTax Notes: {AR7[4]} 62 CostOfSalesAmt. . . . . . . . 14.2 NNN Cost of Sales Amount. . . . . .SALESAMOUNT Read Only:Y Mask:#,###,###, ###.00- Notes: {AR7[5]} 63 SalesSubjectToComm. . . . . . 14.2 NNN Sales Subject to Commission . .SALESAMOUNT Read Only:Y Mask:#,###,###, ###.00- ValGroup:SalespersonR eporting Notes: {AR7[6]} 64 CostSubjectToComm . . . . . . 14.2 NNN Cost Subject To Commission. . .SALESAMOUNT Read Only:Y Mask:#,###,###, ###.00- ValGroup:SalespersonR eporting Notes: {AR7[7]} 65 CommissionAmt . . . . . . . . 14.2 NNN Commission Amount . . . . . . .SALESAMOUNT Mask:#,###,###,###.00- ValGroup:SalespersonReporting Notes: {AR7[8]} 66 RetentionAmt. . . . . . . . . 14.2 NNN Retention Amount. . . . . . . .SALESAMOUNT Mask:#,###,###,###.00- ValGroup:JCIntegrated, JCRetention Notes: {AR7[10]} 67 CorporateSalesTax . . . . . . 12.2 NNN Corporate Sales Tax . . . . . .MISCAMOUNT Mask:##,###,###.00- ValGroup:CreditCard ChngTag:Sum 68 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE Read Only:Y 69 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .TIME Read Only:Y 70 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL 71 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y 72 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .TIME Read Only:Y 73 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL