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$