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