AP_ARClearingHeader AP From AR Clearing Header Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AP_ARClearing_bus
SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_ARClearingHeader.M4T"
KPRIMARY: RecordType+Clear+ARDivisionNo+CustomerNo+CheckNo
Fld Column Name M/L TUR Description/Notes Class
1 RecordType. . . . . . . . . . 1 SYY Record Type . . . . . . . . . .
Notes: {ARM$(1,1)}
2 Clear . . . . . . . . . . . . 5 SNY Clear . . . . . . . . . . . . .
Notes: {ARM$(8,5)}
3 ARDivisionNo. . . . . . . . . 2 SYY AR Division Number. . . . . . .ARDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {APM$(13,2)}
4 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO
FmtType:MASTERNUMC Notes:
{APM$(15,7)}
5 CheckNo . . . . . . . . . . . 10 SNY Check Number. . . . . . . . . .CHECKNO
Notes: {APM$(22,10)}
6 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . .NAME
Notes: {APM$(32,30)}
7 OpenItemCustomer. . . . . . . 1 SYN Open Item Customer. . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{APM$(62,1)}
8 ClearedAmt. . . . . . . . . . 13.2 NNN Cleared Amount. . . . . . . . .AMOUNT
Mask:###,###,###.00- Notes:
{APM[0]}
9 ARBalance . . . . . . . . . . 13.2 NNN AR Balance. . . . . . . . . . .AMOUNT
Mask:###,###,###.00- Notes:
{APM[1]}
10 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
11 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y
12 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
13 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
14 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
15 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000