AP_ManualCheckInvDetailWork AP Manual Check Invoice Detail WorRel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_ManualCheckInvDetailWork"+%S$+".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 Notes: {AP8$(1,1)} 2 CheckNo . . . . . . . . . . . 10 SNY AP Check Number . . . . . . . .APCHECKNO Notes: {AP8$(2,6)} 3 DetailLineKey . . . . . . . . 6 SNY Detail Line Key . . . . . . . . Notes: {AP8$(8,10)} 4 LineKey . . . . . . . . . . . 6 SNY Line Key. . . . . . . . . . . . Mask:000000 5 LineSeqNo . . . . . . . . . . 14 SNY Line Sequence Number. . . . . . Mask:00000000000000 6 AccountKey. . . . . . . . . . 9 SYN Account Key . . . . . . . . . .ACCOUNT DepVal:REQUIRED Notes: {AP8$(1,9)} 7 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO DepVal:REQUIRED ValGroup:JCIn tegrated 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 ValGroup:NotJobNo 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. . . . . . . Notes: {AP8$(120,1)} 16 TransferBox1099 . . . . . . . 3 SNN Transfer 1099 Box . . . . . . . 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:###,###.0000- DepVal:REQ UIRED ValGroup:JCIntegrated, 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]} 24 rowStatus . . . . . . . . . . 1 SYN Row Status. . . . . . . . . . .