AP_JobDistributionDetail AP Job Distribution Detail Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AP_JobDistributionDetail_bus,PO_ReturnRegister_upd,AP_ARClearingRegister_upd,PO_ReceiptRegiste
SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_JobDistributionDetail.M4T"
KPRIMARY: APDivisionNo+VendorNo+InvoiceNo+JobNo+CostCode+CostType
Fld Column Name M/L TUR Description/Notes Class
1 APDivisionNo. . . . . . . . . 2 SNY AP Division Number. . . . . . .APDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {APH$(1,2)}
2 VendorNo. . . . . . . . . . . 7 SYY Vendor Number . . . . . . . . .VENDORNO
FmtType:MASTERNUM ChngTag:Rep
lace1/APDivisionNo$ Notes:
{APH$(3,7)}
3 InvoiceNo . . . . . . . . . . 10 SYY AP Invoice Number . . . . . . .APINVOICE
Notes: {APH$(10,10)}
4 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO
FmtType:CHARNUM Notes:
{APH$(20,7)}
5 CostCode. . . . . . . . . . . 9 SYN Cost Code . . . . . . . . . . .COSTCODE
Notes: {APH$(27,9)}
6 CostType. . . . . . . . . . . 1 SYN Cost Type . . . . . . . . . . .COSTTYPE
Notes: {APH$(36,1)}
7 DistributionAmt . . . . . . . 13.2 NNN Distribution Amount . . . . . .AMOUNT
Mask:###,###,###.00-
ChngTag:Sum Notes: {APH[0]}
8 RetentionAmt. . . . . . . . . 13.2 NNN Retention Amount. . . . . . . .AMOUNT
Mask:###,###,###.00-
ChngTag:Sum Notes: {APH[1]}
9 Balance . . . . . . . . . . . 13.2 NNN Balance . . . . . . . . . . . .AMOUNT
Mask:###,###,###.00
ChngTag:Sum Notes: {APH[2]}
10 AmountAppliedToday. . . . . . 13.2 NNN Amount Applied Today. . . . . .AMOUNT
Mask:###,###,###.00-
ChngTag:Sum Notes: {APH[3]}
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 SNN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
ChngTag:CopyMax/DateUpdated$