| Name | Description | Type | Additional information |
|---|---|---|---|
| DOC_NO | integer |
None. |
|
| DOC_TYPE | string |
None. |
|
| DOC_CATEGORY | string |
None. |
|
| CHECK_NO | string |
None. |
|
| DOC_STATUS | integer |
None. |
|
| CHECK_COUNTER | string |
None. |
|
| CRDT_DOC_NO | integer |
None. |
|
| CRDT_LINE | decimal number |
None. |
|
| CRDT_DOC_TYPE | string |
None. |
|
| CRDT_DOC_CATEGORY | string |
None. |
|
| CRDT_CHECK_NO | string |
None. |
|
| MANUAL_AUTO | string |
None. |
|
| AUTO_BATCH | integer |
None. |
|
| STATUS | integer |
None. |
|
| BANK_ID | string |
None. |
|
| ACCOUNT_NO | string |
None. |
|
| CHECKBOOK_NO | string |
None. |
|
| ACCTNO | string |
None. |
|
| SUBC | string |
None. |
|
| PAYTO | integer |
None. |
|
| PAYTO_SUBC | string |
None. |
|
| PAYTO_CCODE | string |
None. |
|
| CUST_VEND | string |
None. |
|
| CHECK_DATE | date |
None. |
|
| PAYMENT_DATE | date |
None. |
|
| NOTE | string |
None. |
|
| PAYEE | string |
None. |
|
| GL_CODE | string |
None. |
|
| COMPANYNO | integer |
None. |
|
| DIVISION | string |
None. |
|
| DEPART | string |
None. |
|
| LAST_STATEMENT_BALANCE | decimal number |
None. |
|
| INFO_BANK_ID | string |
None. |
|
| INFO_BANK_NAME | string |
None. |
|
| INFO_SWIFT | string |
None. |
|
| INFO_ACCOUNT_NO | string |
None. |
|
| INFO_BRANCH_NO | string |
None. |
|
| WIRE_PROCESS_DATE | date |
None. |
|
| WIRE_FILE_NAME | string |
None. |
|
| CC_CREDITCARD | string |
None. |
|
| CC_NAME | string |
None. |
|
| CC_NUMBER | string |
None. |
|
| CC_EXP | date |
None. |
|
| PRINT_DATE | date |
None. |
|
| POST_GL_DATE | date |
None. |
|
| POST_GL | string |
None. |
|
| BATCH_NO | integer |
None. |
|
| BATCH_DATE | date |
None. |
|
| STATEMENT_DOC_NO | integer |
None. |
|
| DEPOSIT_DOC_NO | integer |
None. |
|
| CLEARED | string |
None. |
|
| CLEARED_BY | string |
None. |
|
| CLEARED_ON | date |
None. |
|
| CLEARED_CURRENCY_STATE | string |
None. |
|
| PRINTED_ON | date |
None. |
|
| CURENCY_STATE | string |
None. |
|
| CURENCY_BASE | string |
None. |
|
| CURENCY_CONV | string |
None. |
|
| CURENCY_FACTOR | decimal number |
None. |
|
| CURENCY_DATE | date |
None. |
|
| DISCOUNT | decimal number |
None. |
|
| DISCOUNT_DISCREPANCY | decimal number |
None. |
|
| NETAMOUNT | decimal number |
None. |
|
| NETAMOUNT_DISCREPANCY | decimal number |
None. |
|
| AMOUNT | decimal number |
None. |
|
| APPLIED | decimal number |
None. |
|
| CURRENCY_DISCREPANCY | decimal number |
None. |
|
| OPEN_BALANCE | decimal number |
None. |
|
| C_AMOUNT | decimal number |
None. |
|
| C_DISCOUNT | decimal number |
None. |
|
| C_DISCOUNT_DISCREPANCY | decimal number |
None. |
|
| C_NETAMOUNT | decimal number |
None. |
|
| C_NETAMOUNT_DISCREPANCY | decimal number |
None. |
|
| C_APPLIED | decimal number |
None. |
|
| C_CURRENCY_DISCREPANCY | decimal number |
None. |
|
| C_OPEN_BALANCE | decimal number |
None. |
|
| ORIG_DISCOUNT | decimal number |
None. |
|
| ORIG_DISCOUNT_DISCREPANCY | decimal number |
None. |
|
| ORIG_NETAMOUNT | decimal number |
None. |
|
| ORIG_NETAMOUNT_DISCREPANCY | decimal number |
None. |
|
| ORIG_AMOUNT | decimal number |
None. |
|
| ORIG_APPLIED | decimal number |
None. |
|
| ORIG_OPEN_BALANCE | decimal number |
None. |
|
| C_ORIG_AMOUNT | decimal number |
None. |
|
| C_ORIG_DISCOUNT | decimal number |
None. |
|
| C_ORIG_DISCOUNT_DISCREPANCY | decimal number |
None. |
|
| C_ORIG_NETAMOUNT | decimal number |
None. |
|
| C_ORIG_NETAMOUNT_DISCREPANCY | decimal number |
None. |
|
| C_ORIG_APPLIED | decimal number |
None. |
|
| C_ORIG_OPEN_BALANCE | decimal number |
None. |
|
| PAID_BY_ACH | string |
None. |
|
| ACH_ACCOUNT_NO | string |
None. |
|
| ACH_ACCOUNT_NAME | string |
None. |
|
| ACH_TRANSACTION_CODE | string |
None. |
|
| ACH_BANK_NAME | string |
None. |
|
| ACH_ROUTING_NO | string |
None. |
|
| BRANCH_NO | string |
None. |
|
| BANK_NO | string |
None. |
|
| BANK_NAME | string |
None. |
|
| ACCOUNT_CURRENCY | string |
None. |
|
| ACCOUNT_AMOUNT | decimal number |
None. |
|
| ACCOUNT_FACTOR | decimal number |
None. |
|
| ACCOUNT_FACTOR_DATE | date |
None. |
|
| TRANSFER_GL_CODE | string |
None. |
|
| ACCOUNT_ORIG_AMOUNT | decimal number |
None. |
|
| SIGN_1 | string |
None. |
|
| SIGN_2 | string |
None. |
|
| SIGN_3 | string |
None. |
|
| SIGN_4 | string |
None. |
|
| SIGN_5 | string |
None. |
|
| SIGN_1_APR | string |
None. |
|
| SIGN_2_APR | string |
None. |
|
| SIGN_3_APR | string |
None. |
|
| SIGN_4_APR | string |
None. |
|
| SIGN_5_APR | string |
None. |
|
| SIGN_1_DATE | date |
None. |
|
| SIGN_2_DATE | date |
None. |
|
| SIGN_3_DATE | date |
None. |
|
| SIGN_4_DATE | date |
None. |
|
| SIGN_5_DATE | date |
None. |
|
| APPLIED_BY | string |
None. |
|
| RECLOCK | string |
None. |
|
| ADDED_USR | string |
None. |
|
| ADDED_DTE | date |
None. |
|
| UPDATED_USR | string |
None. |
|
| UPDATED_DTE | date |
None. |