AP_ManualCheckInvDetail AP Manual Check Invoice Detail Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_ManualCheckInvDetail_bus Mirror: AP_ManualCheckInvDetailWork SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_ManualCheckInvDetail.M4T"
KPRIMARY: BankCode+CheckNo+DetailLineKey+LineKey KDISPLAY: BankCode+CheckNo+DetailLineKey+LineSeqNo+LineKey
Fld Column Name M/L TUR Description/Notes Class
1 BankCode. . . . . . . . . . . 1 SNY Bank Code . . . . . . . . . . .BANKCODE Read Only:Y Notes: {AP8$(1, 1)} 2 CheckNo . . . . . . . . . . . 10 SNY AP Check Number . . . . . . . .APCHECKNO Read Only:Y Notes: {AP8$(2, 6)} 3 DetailLineKey . . . . . . . . 6 SNY Detail Line Key . . . . . . . . Read Only:Y Notes: {AP8$(8, 10)} 4 LineKey . . . . . . . . . . . 6 SNY Line Key. . . . . . . . . . . . Read Only:Y Mask:000000 5 LineSeqNo . . . . . . . . . . 14 SNY Line Sequence Number. . . . . . Read Only:Y Mask:000000000000 00 6 AccountKey. . . . . . . . . . 9 SYN Account Key . . . . . . . . . .ACCOUNT DepVal:REQUIRED Notes: {AP8$(1,9)} 7 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO FmtType:CHARNUM DepVal:REQUIR ED ValGroup:JCIntegrated Notes: {AP8$(10.7)} 8 CostCode. . . . . . . . . . . 9 SYN Cost Code . . . . . . . . . . .COSTCODE DepVal:REQUIRED ValGroup:JCIn tegrated,JobNo Notes: {AP8$(17,9)} 9 CostType. . . . . . . . . . . 1 SYN Cost Type . . . . . . . . . . .COSTTYPE DepVal:REQUIRED ValGroup:JCIn tegrated,JobNo Notes: {AP8$(26,1)} 10 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . .UNITOFMEASURE DepVal:REQUIRED ValGroup:JCIn tegrated,JobNo Notes: {AP8$(27,4)} 11 CommentText . . . . . . . . . 2048 SNN Comment . . . . . . . . . . . .COMMENT Notes: {AP8$(31,20)} 12 TransferAPDivisionNo. . . . . 2 SNN Transfer AP Division Number . .APDIVISION Mask:00 ValGroup:NotJobNo Notes: {AP8$(101,2)} 13 TransferVendorNo. . . . . . . 7 SYN Transfer Vendor Number. . . . .VENDORNO DepVal:REQUIRED ValGroup:NotJ obNo Notes: {AP8$(103,7)} 14 TransferInvoiceNo . . . . . . 10 SNN Transfer AP Invoice Number. . .APINVOICE DepVal:REQUIRED ValGroup:NotJ obNo Notes: {AP8$(110,10)} 15 TransferForm1099. . . . . . . 1 SNN Transfer 1099 Form. . . . . . .FORM1099 Notes: {AP8$(120,1)} 16 TransferBox1099 . . . . . . . 3 SNN Transfer 1099 Box . . . . . . .BOX1099 Notes: {AP8$(121,2)} 17 AssetTemplate . . . . . . . . 25 SNN Asset Template. . . . . . . . .ASSETTEMPLATE DepVal:REQUIRED ValGroup:FAIn tegration 18 QuantityDistributed . . . . . 16.6 NNN Quantity Distributed. . . . . .QUANTITY Mask:##,###,###.000000- DepVal:REQUIRED ValGroup:JCIn tegrated,JobNo Notes: {AP8[0]} 19 DistributionAmt . . . . . . . 13.2 NNN Distribution Amount . . . . . .AMOUNT Mask:##,###,###.00- Notes: {AP8[1]} 20 RetentionRate . . . . . . . . 7.2 NNN Amount. . . . . . . . . . . . .AMOUNT Mask:###.00-% DepVal:REQUIRED ValGroup:JCIntegrated,JobNo Notes: {AP8[2]} 21 UnitCost. . . . . . . . . . . 16.6 NNN Unit Cost . . . . . . . . . . .COST Mask:##,###,###.000000- DepVal:REQUIRED ValGroup:JCIn tegrated,JobNo Notes: {AP8[3]} 22 RetentionAmt. . . . . . . . . 13.2 NNN Amount. . . . . . . . . . . . .AMOUNT Mask:###,###,###.00- Notes: {AP8[4]} 23 TransferDiscount. . . . . . . 13.2 NNN Amount. . . . . . . . . . . . .AMOUNT Mask:###,###,###.00- Notes: {AP8[5]}