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