AR_OpenInvoice AR Open Invoice Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AR_OpenInvoice_bus,AR_SalesJournal_upd,SO_SalesJournal_upd,AR_FinanceChargeJournal_upd,AR_Cash
SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_OpenInvoice.M4T"
KPRIMARY: ARDivisionNo+CustomerNo+InvoiceNo+InvoiceType
KINVOICE: ARDivisionNo+CustomerNo+InvoiceDate+InvoiceNo+InvoiceType
KINVOICEDECENDING: ARDivisionNo+CustomerNo+InvoiceDate(d)+InvoiceNo+InvoiceType
Fld Column Name M/L TUR Description/Notes Class
1 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {AR4$(1,2)}
2 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO
FmtType:MASTERNUMC ChngTag:Re
place1/ARDivisionNo$ Notes:
{AR4$(3,7)}
3 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE
FmtType:MASTERNUM Notes:
Payment Date {AR4$(10,7)}
4 InvoiceType . . . . . . . . . 2 SYY Invoice Type. . . . . . . . . .
Valid:CM,DM,FC,IN,PP,PY,BC,
BF Notes: CM=Credit Memo,
DM=Debit Memo, FC=Finance
Charge, IN=INvoice,
PP=PrePayment, PY=PaYment,
BC=Balance forward other
Charges, BF=Balance Forward
{AR4$(17,2)}
5 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE
ChngTag:Min Notes: {AR4$(19,
6)}
6 InvoiceDueDate. . . . . . . . 8 SNN Invoice Due Date. . . . . . . .DATE
ChngTag:Min Notes: {AR4$(25,
6)}
7 InvoiceDiscountDate . . . . . 8 SNN Invoice Discount Date . . . . .DATE
ChngTag:Min Notes: {AR4$(31,
6)}
8 InvoiceHistoryHeaderSeqNo . . 6 SNN Invoice History Header Sequence
Mask:000000
9 PostingDate . . . . . . . . . 8 SNN Last Payment Posting Date . . .DATE
ChngTag:Min Notes: {AR4$(59,
6)}
10 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . .ARTERMS
Mask:00 FmtType:ZEROFILL
Notes: {AR4$(37,2)}
11 TaxSchedule . . . . . . . . . 9 SYN Tax Schedule. . . . . . . . . .TAXSCHEDULE
FmtType:CHARNUM Notes:
{AR4$(39,9)}
12 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . .ARDIVISION
Mask:00 FmtType:ZEROFILL
13 SalespersonNo . . . . . . . . 4 SYN Salesperson Number. . . . . . .SALESPERSONNO
FmtType:CHARNUM Notes:
{AR4$(48,4)}
14 SplitCommissionFlag . . . . . 1 SYN Split Commission Flag . . . . .
Valid:Y,N,O Notes: Y=Yes,
N=No, O=Override {AR4$(52,1)}
15 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .COMMENT30
Notes: {AR4$(65,30)}
16 CreditMemoInvoiceReference. . 7 SYN Credit Memo Invoice Reference .
FmtType:CHARNUM Notes:
{AR4$(95,7)}
17 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO
FmtType:CHARNUM Notes:
{AR4$(102,7)}
18 CustomerPONo. . . . . . . . . 15 SNN Customer PO Number. . . . . . .CUSTOMERPONO
Notes: {AR4$(109,15)}
19 PostingReference. . . . . . . 10 SNN Posting Reference . . . . . . .
Notes: {AR4$(124,10)}
20 CheckNo . . . . . . . . . . . 10 SYN Check Number. . . . . . . . . .CHECKNO
FmtType:ALPHANUM Notes:
{AR4$(124,10)}
21 CommissionRate. . . . . . . . 9.3 NNN Commission Rate . . . . . . . .COMMISSIONRATE
Mask:###0.000 Notes: {AR4[0]}
22 TaxableAmt. . . . . . . . . . 14.2 NNN Taxable Amount. . . . . . . . .
Mask:#,###,###,###.00-
ChngTag:Sum Notes: Payment
Amount {AR4[1]}
23 NonTaxableAmt . . . . . . . . 14.2 NNN Non-Taxable Amount. . . . . . .
Mask:#,###,###,###.00-
ChngTag:Sum Notes: {AR4[2]}
24 FreightAmt. . . . . . . . . . 13.2 NNN Freight Amount. . . . . . . . .
Mask:###,###,###.00-
ChngTag:Sum Notes: {AR4[3]}
25 SalesTaxAmt . . . . . . . . . 13.2 NNN Sales Tax Amount. . . . . . . .
Mask:###,###,###.00-
ChngTag:Sum Notes: {AR4[4]}
26 CostOfSalesAmt. . . . . . . . 14.2 NNN Cost Of Sales Amount. . . . . .
Mask:#,###,###,###.00-
ChngTag:Sum Notes: {AR4[5]}
27 SalesSubjectToComm. . . . . . 14.2 NNN Sales Subject To Commission . .
Mask:#,###,###,###.00-
ChngTag:Sum Notes: {AR4[6]}
28 CostSubjectToComm . . . . . . 14.2 NNN Cost Subject To Commission. . .
Mask:#,###,###,###.00-
ChngTag:Sum Notes: {AR4[7]}
29 CommissionAmt . . . . . . . . 13.2 NNN Commission Amount . . . . . . .
Mask:###,###,###.00-
ChngTag:Sum Notes: {AR4[8]}
30 DiscountAmt . . . . . . . . . 14.2 NNN Discount Amount . . . . . . . .
Mask:#,###,###,###.00-
ChngTag:Sum Notes: {AR4[9]}
31 PaymentsToday . . . . . . . . 14.2 NNN Payments Today. . . . . . . . .
Mask:#,###,###,###.00-
ChngTag:Sum Notes: {AR4[10]}
32 Balance . . . . . . . . . . . 14.2 NNN Balance . . . . . . . . . . . .
Mask:#,###,###,###.00-
ChngTag:Sum Notes: Balance
Forward {AR4[11]}
33 RetentionAmt. . . . . . . . . 14.2 NNN Retention Amount. . . . . . . .
Mask:#,###,###,###.00-
ChngTag:Sum Notes: * Bal Fwd
Accts - Payment Date Can Be
Ppmmdd Or Mmmddyy (Apr0499)
{AR4[12]}
34 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y ChngTag:Max
Notes: YYYYMMDD
35 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y ChngTag:CopyMax/D
ateUpdated$
36 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL ChngTag:Copy
Max/DateUpdated$