| FIELD NAME |
TYPE |
LENGTH |
QRY |
MOD |
INS |
REQ INS |
VALIDATE |
REL |
| PayeeEntityRefListID |
Varchar |
36 |
True |
False |
False |
N/A |
String |
|
| PayeeEntityRefFullName |
Varchar |
159 |
True |
False |
False |
N/A |
String |
|
| DueDateCutoff |
Date |
10 |
True |
False |
False |
N/A |
CCCC-MM-DD |
|
| BillToPayTxnID |
Varchar |
36 |
True |
False |
False |
N/A |
String |
|
| BillToPayTxnType |
Varchar |
14 |
True |
False |
False |
N/A |
Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjustment Paycheck PayrollLiabilityCheck PurchaseOrder ReceivePayment SalesOrder SalesReceipt SalesTaxPaymentCheck Transfer VendorCredit YTDAdjustment ARRefundCreditCard |
|
| BillToPayTxnNumber |
Integer |
13 |
True |
False |
False |
N/A |
11.0 |
|
| BillToPayAPAccountRefListID |
Varchar |
36 |
True |
False |
False |
N/A |
String |
|
| BillToPayAPAccountRefFullName |
Varchar |
159 |
True |
False |
False |
N/A |
String |
|
| BillToPayTxnDate |
Date |
10 |
True |
False |
False |
N/A |
CCCC-MM-DD |
|
| BillToPayRefNumber |
Varchar |
20 |
True |
False |
False |
N/A |
String |
|
| BillToPayDueDate |
Date |
10 |
True |
False |
False |
N/A |
CCCC-MM-DD |
|
| BillToPayAmountDue |
Decimal |
11 |
True |
False |
False |
N/A |
8.2 |
|
| CreditToApplyTxnID |
Varchar |
36 |
True |
False |
False |
N/A |
String |
|
| CreditToApplyTxnType |
Varchar |
14 |
True |
False |
False |
N/A |
Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjustment Paycheck PayrollLiabilityCheck PurchaseOrder ReceivePayment SalesOrder SalesReceipt SalesTaxPaymentCheck Transfer VendorCredit YTDAdjustment ARRefundCreditCard |
|
| CreditToApplyTxnNumber |
Integer |
13 |
True |
False |
False |
N/A |
11.0 |
|
| CreditToApplyAPAccountRefListID |
Varchar |
36 |
True |
False |
False |
N/A |
String |
|
| CreditToApplyAPAccountRefFullName |
Varchar |
159 |
True |
False |
False |
N/A |
String |
|
| CreditToApplyTxnDate |
Date |
10 |
True |
False |
False |
N/A |
CCCC-MM-DD |
|
| CreditToApplyRefNumber |
Varchar |
20 |
True |
False |
False |
N/A |
String |
|
| CreditToApplyCreditRemaining |
Decimal |
11 |
True |
False |
False |
N/A |
8.2 |
|
| FQPrimaryKey |
Varchar |
73 |
True |
False |
False |
N/A |
FQPrimaryKey |
|