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]}