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$