AR_CashSales AR Cash Sales Transactions Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AR_SalesJournal_upd,SO_SalesJournal_upd,AR_CommissionEditRegister_upd SQL Def: N SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_CashSales.M4T"
KPRIMARY: ARDivisionNo+CustomerNo+InvoiceNo+InvoiceType+SequenceNo
Fld Column Name M/L TUR Description/Notes Class
1 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION FmtType:ZEROFILL 2 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO FmtType:MASTERNUMC ChngTag:Re place1/ARDivisionNo$ Notes: {ARS$(3,7)} 3 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE FmtType:MASTERNUM Notes: {ARS$(10,7)} 4 InvoiceType . . . . . . . . . 2 SYY Invoice Type. . . . . . . . . . Valid:CM,DM,IN,FC,CA Notes: CM=Credit Memo, DM=Debit Memo, IN=INvoice, FC=Finance Charge, CA=CAsh {ARS$(17,2)} 5 SequenceNo. . . . . . . . . . 6 SNY Sequence Number . . . . . . . . Mask:000000 FmtType:ZEROFILL ChngTag:KeySeq Notes: {ARS$(19,3)} 6 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE Notes: {ARS$(22,6)} 7 InvoiceDueDate. . . . . . . . 8 SNN Invoice Due Date. . . . . . . .DATE Notes: {ARS$(28,6)} 8 InvoiceDiscountDate . . . . . 8 SNN Invoice Discount Date . . . . .DATE Notes: {ARS$(34,6)} 9 TransactionDate . . . . . . . 8 SNN Transaction Date. . . . . . . .DATE Notes: {ARS$(40,6)} 10 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . .ARTERMS Mask:00 FmtType:ZEROFILL Notes: {ARS$(46,2)} 11 TaxSchedule . . . . . . . . . 9 SYN Tax Schedule. . . . . . . . . .TAXSCHEDULE Notes: {ARS$(48,9)} 12 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . .ARDIVISION Mask:00 FmtType:ZEROFILL 13 SalespersonNo . . . . . . . . 4 SYN Salesperson Number. . . . . . .SALESPERSONNO FmtType:CHARNUM Notes: {ARS$(57,4)} 14 SplitCommission . . . . . . . 1 SYN Split Commission. . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {ARS$(61,1)} 15 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO FmtType:CHARNUM Notes: {ARS$(62,7)} 16 CommissionRate. . . . . . . . 9.3 NNN Commission Rate . . . . . . . .COMMISSIONRATE Mask:###0.000 Notes: {ARS[0]} 17 TaxableAmt. . . . . . . . . . 13.2 NNN Taxable Amount. . . . . . . . .AMOUNT Mask:###,###,###.00 Notes: {ARS[1]} 18 NonTaxableAmt . . . . . . . . 13.2 NNN Non-Taxable Amount. . . . . . .AMOUNT Mask:###,###,###.00 Notes: {ARS[2]} 19 FreightAmt. . . . . . . . . . 12.2 NNN Freight Amount. . . . . . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {ARS[3]} 20 SalesTaxAmt . . . . . . . . . 12.2 NNN Sales Tax Amount. . . . . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {ARS[4]} 21 CostOfSalesAmt. . . . . . . . 13.2 NNN Cost Of Sales Amount. . . . . .AMOUNT Mask:###,###,###.00 Notes: {ARS[5]} 22 SalesSubjectToComm. . . . . . 13.2 NNN Sales Subject To Commission . .AMOUNT Mask:###,###,###.00 Notes: {ARS[6]} 23 CostSubjectToComm . . . . . . 13.2 NNN Cost Subject To Commission. . .AMOUNT Mask:###,###,###.00 Notes: {ARS[7]} 24 CommissionAmt . . . . . . . . 13.2 NNN Commission Amount . . . . . . .AMOUNT Mask:###,###,###.00 Notes: {ARS[8]} 25 RetentionAmt. . . . . . . . . 13.2 NNN Retention Amount. . . . . . . .AMOUNT Mask:###,###,###.00 Notes: {ARS[9]} 26 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 27 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y 28 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL