AR_CustomerSalesHistory AR Customer Sales History Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AR_CustomerSalesHistory_bus,AR_CashReceiptsJournal_upd,AR_SalesJournal_upd,SO_SalesJournal_upd
SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_CustomerSalesHistory.M4T"
KPRIMARY: ARDivisionNo+CustomerNo+FiscalYear+FiscalPeriod
KALTERNATE: FiscalYear+FiscalPeriod+ARDivisionNo+CustomerNo
KYEARPERIOD: FiscalYear(d**)+FiscalPeriod+ARDivisionNo+CustomerNo **=Case Sensitive
Fld Column Name M/L TUR Description/Notes Class
1 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION
Mask:00 FmtType:ZEROFILL
2 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO
FmtType:MASTERNUMC ChngTag:Re
place1/ARDivisionNo$
3 FiscalYear. . . . . . . . . . 4 SNY Fiscal Year . . . . . . . . . .YEAR
Mask:0000
4 FiscalPeriod. . . . . . . . . 2 SNY Fiscal Period . . . . . . . . .FISCALPERIOD
Mask:00 FmtType:ZEROFILL
5 DollarsSold . . . . . . . . . 15.2 NNN Dollars Sold. . . . . . . . . .
Mask:##,###,###,###.00-
ChngTag:Sum
6 CostOfGoodsSold . . . . . . . 15.2 NNN Cost of Goods Sold. . . . . . .
Mask:##,###,###,###.00-
ChngTag:Sum
7 CashReceived. . . . . . . . . 15.2 NNN Cash Received . . . . . . . . .
Mask:##,###,###,###.00-
ChngTag:Sum
8 FinanceCharges. . . . . . . . 15.2 NNN Finance Charges . . . . . . . .
Mask:##,###,###,###.00-
ChngTag:Sum
9 NumberOfInvoices. . . . . . . 7.0 NNN Number of Invoices. . . . . . .
Mask:#,###,### ChngTag:Sum
10 NumberOfFinanceChrgs. . . . . 7.0 NNN Number of Finance Charges . . .
Mask:#,###,### ChngTag:Sum
11 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y ChngTag:Max
Notes: YYYYMMDD
12 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y ChngTag:CopyMax/D
ateUpdated$
13 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL ChngTag:Copy
Max/DateUpdated$