AP_RepetitiveInvoiceHeader AP Repetitive Invoice Header Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AP_RepetitiveInvoice_bus
SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_RepetitiveInvoiceHeader.M4T"
KPRIMARY: APDivisionNo+VendorNo+ReferenceNo
Fld Column Name M/L TUR Description/Notes Class
1 APDivisionNo. . . . . . . . . 2 SNY AP Division Number. . . . . . .APDIVISION
Mask:00 FmtType:ZEROFILL
ValGroup:APDivisionRequired
Notes: {APF$(1,2)}
2 VendorNo. . . . . . . . . . . 7 SYY Vendor Number . . . . . . . . .VENDORNO
FmtType:MASTERNUM ChngTag:Rep
lace1/APDivisionNo$ Notes:
{APF$(3,7)}
3 ReferenceNo . . . . . . . . . 4 SYY Reference Number. . . . . . . .
FmtType:CHARNUM Notes:
{APF$(10,4)}
4 SelectCycleCode . . . . . . . 2 SYN Select Cycle Code . . . . . . .
FmtType:CHARNUM Notes:
{APF$(14,2)}
5 StartBillingDate. . . . . . . 8 SNN Start Billing Date. . . . . . .DATE
Notes: {APF$(16,6)}
6 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . .APTERMS
Mask:00 FmtType:ZEROFILL
DepVal:REQUIRED Notes:
{APF$(22,2)}
7 Comment . . . . . . . . . . . 40 SNN Comment . . . . . . . . . . . .
Notes: {APF$(24,30)}
8 LastBilledDate. . . . . . . . 8 SNN Last Billed Date. . . . . . . .DATE
Notes: {APF$(54,6)}
9 Form1099. . . . . . . . . . . 1 SNN 1099 Form . . . . . . . . . . .FORM1099
ValGroup:TEN99 Notes:
{APF$(60,1)}
10 Box1099 . . . . . . . . . . . 3 SNN 1099 Box. . . . . . . . . . . .BOX1099
ValGroup:TEN99 Notes:
{APF$(61,2)}
11 SeparateCheck . . . . . . . . 1 SYN Separate Check. . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{APF$(63,1)}
12 TaxSchedule . . . . . . . . . 9 SYN Tax Schedule. . . . . . . . . .TAXSCHEDULE
FmtType:CHARNUM DepVal:REQUIR
ED ValGroup:APSalesTax
Notes: {APF$(64,9)}
13 TaxClass. . . . . . . . . . . 2 SYN Tax Class . . . . . . . . . . .TAXCLASS
DepVal:REQUIRED ValGroup:APSa
lesTax Notes: {APF$(73,2)}
14 UseTax. . . . . . . . . . . . 1 SYN Use Tax . . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
ValGroup:APSalesTax Notes:
{APF$(75,1)}
15 NumberOfPaymentsToMake. . . . 5.0 NNN Number Of Payments To Make. . .
Mask:##0 Notes: {APF[0]}
16 NumberOfPaymentsMade. . . . . 5.0 NNN Number Of Payments Made . . . .
Mask:##0 Notes: {APF[1]}
17 InvoiceAmt. . . . . . . . . . 13.2 NNN Invoice Amount. . . . . . . . .AMOUNT
Mask:###,###,###.00- Notes:
{APF[2]}
18 NetInvoiceAmt . . . . . . . . 13.2 NNN Net Invoice Amount. . . . . . .AMOUNT
Mask:###,###,###.00- Notes:
{APF[3]}
19 DiscountAmt . . . . . . . . . 13.2 NNN Discount Amount . . . . . . . .AMOUNT
Mask:###,###,###.00-
ValSeqNo:9999 Notes: {APF[4]}
20 OriginalBalance . . . . . . . 13.2 NNN Original Balance. . . . . . . .AMOUNT
Mask:###,###,###.00- Notes:
{APF[5]}
21 BilledToDateAmt . . . . . . . 13.2 NNN Billed To Date Amount . . . . .AMOUNT
Mask:###,###,###.00- Notes:
{APF[6]}
22 TaxableAmt. . . . . . . . . . 13.2 NNN Taxable Amount. . . . . . . . .AMOUNT
Read Only:Y Mask:###,###,
###.00- ValGroup:APSalesTax
Notes: {APF[8]}
23 NonTaxableAmt . . . . . . . . 13.2 NNN Non-Taxable Amount. . . . . . .AMOUNT
Read Only:Y Mask:###,###,
###.00- Notes: {APF[9]}
24 FreightAmt. . . . . . . . . . 13.2 NNN Freight Amount. . . . . . . . .AMOUNT
Mask:###,###,###.00- Notes:
{APF[10]}
25 TaxAmt. . . . . . . . . . . . 13.2 NNN Tax Amount. . . . . . . . . . .AMOUNT
Mask:###,###,###.00-
ValSeqNo:9999 Notes:
{APF[11]}
26 NonRecoverableAmt . . . . . . 13.2 NNN Non-Recoverable Amount. . . . .AMOUNT
Mask:###,###,###.00- Notes:
{APF[12]}
27 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
28 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y
29 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
30 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
31 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
32 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000