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