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$