This table contains details of Payables payment and check Information.
Module: Payables
CHECK_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
CHECK_ID | NUMBER | 38 | 0 | True | |||
SOURCE_RECORD_ID | VARCHAR2 | 128 | Source record identifier. | ||||
SUBLEDGER_LINKAGE_HDR_ENTITY_ID | VARCHAR2 | 128 | |||||
ACTUAL_VALUE_DATE | DATE | ||||||
ADDRESS_LINE1 | VARCHAR2 | 256 | |||||
ADDRESS_LINE2 | VARCHAR2 | 256 | |||||
ADDRESS_LINE3 | VARCHAR2 | 256 | |||||
ADDRESS_LINE4 | VARCHAR2 | 256 | |||||
ADDRESS_STYLE | VARCHAR2 | 32 | |||||
AMOUNT | NUMBER | ||||||
ANTICIPATED_VALUE_DATE | DATE | ||||||
BANK_ACCOUNT_NAME | VARCHAR2 | 128 | |||||
BANK_ACCOUNT_NUM | VARCHAR2 | 32 | |||||
BANK_ACCOUNT_TYPE | VARCHAR2 | 32 | |||||
BANK_CHARGE_BEARER | VARCHAR2 | 32 | |||||
BANK_NUM | VARCHAR2 | 32 | |||||
BASE_AMOUNT | NUMBER | ||||||
CEBANK_ACCT_USE_ID | NUMBER | 38 | 0 | ||||
CHECK_DATE | DATE | ||||||
CHECK_FORMAT_ID | NUMBER | 38 | 0 | ||||
CHECK_NUMBER | NUMBER | 38 | 0 | ||||
CHECK_STOCK_ID | NUMBER | 38 | 0 | ||||
CHECK_VOUCHER_NUM | NUMBER | 38 | 0 | ||||
CHECK_RUN_ID | NUMBER | 38 | 0 | ||||
CHECK_RUN_NAME | VARCHAR2 | 256 | |||||
CITY | VARCHAR2 | 64 | |||||
CLEARED_AMOUNT | NUMBER | ||||||
CLEARED_BASE_AMOUNT | NUMBER | ||||||
CLEARED_CHARGES_AMOUNT | NUMBER | ||||||
CLEARED_CHARGES_BASE_AMOUNT | NUMBER | ||||||
CLEARED_DATE | DATE | ||||||
CLEARED_ERROR_AMOUNT | NUMBER | ||||||
CLEARED_ERROR_BASE_AMOUNT | NUMBER | ||||||
CLEARED_EXCHANGE_DATE | DATE | ||||||
CLEARED_EXCHANGE_RATE | NUMBER | ||||||
CLEARED_EXCHANGE_RATE_TYPE | VARCHAR2 | 32 | |||||
COMPLETED_PMTS_GROUP_ID | NUMBER | 38 | 0 | ||||
COUNTRY | VARCHAR2 | 64 | |||||
COUNTY | VARCHAR2 | 256 | |||||
CREATED_BY | VARCHAR2 | 64 | |||||
CREATION_DATE | TIMESTAMP | ||||||
CURRENCY_CODE | VARCHAR2 | 16 | |||||
DESCRIPTION | VARCHAR2 | 256 | |||||
DOC_CATEGORY_CODE | VARCHAR2 | 32 | |||||
DOC_SEQUENCE_ID | NUMBER | 38 | 0 | ||||
DOC_SEQUENCE_VALUE | NUMBER | ||||||
EMPLOYEE_ADDRESS_CODE | VARCHAR2 | 16 | |||||
EXCHANGE_DATE | DATE | ||||||
EXCHANGE_RATE | NUMBER | ||||||
EXCHANGE_RATETYPE | VARCHAR2 | 32 | |||||
EXTERNAL_BANK_ACCOUNT_ID | NUMBER | 38 | 0 | ||||
FUTURE_PAY_DUE_DATE | DATE | ||||||
IBAN_NUMBER | VARCHAR2 | 64 | |||||
LAST_UPDATE_DATE | TIMESTAMP | ||||||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | |||||
LAST_UPDATED_BY | VARCHAR2 | 64 | |||||
LEGAL_ENTITY_ID | NUMBER | 38 | 0 | ||||
LOGICAL_GROUP_REFERENCE | VARCHAR2 | 32 | |||||
MATURITY_EXCHANGE_DATE | DATE | ||||||
MATURITY_EXCHANGE_RATE | NUMBER | ||||||
MATURITY_EXCHANGE_RATE_TYPE | VARCHAR2 | 32 | |||||
OBJECT_VERSION_NUMBER | NUMBER | 38 | 0 | ||||
ORG_ID | NUMBER | 38 | 0 | ||||
PARTY_ID | NUMBER | 38 | 0 | ||||
PARTY_SITEID | NUMBER | 38 | 0 | ||||
PAYMENT_DOCUMENT_ID | NUMBER | 38 | 0 | ||||
PAYMENT_ID | NUMBER | 38 | 0 | ||||
PAYMENT_INSTRUCTION_ID | NUMBER | 38 | 0 | ||||
PAYMENT_METHOD_CODE | VARCHAR2 | 32 | |||||
PAYMENT_METHOD_LOOKUP_CODE | VARCHAR2 | 32 | |||||
PAYMENT_PROFILE_ID | NUMBER | 38 | 0 | ||||
PAYMENT_TYPE_FLAG | VARCHAR2 | 32 | |||||
POSITIVE_PAY_STATUS_CODE | VARCHAR2 | 32 | |||||
PROVINCE | VARCHAR2 | 256 | |||||
RECON_FLAG | VARCHAR2 | 16 | |||||
RECON_CILIATION_BATCH_ID | NUMBER | 38 | 0 | ||||
RELATIONSHIP_ID | NUMBER | 38 | 0 | ||||
RELEASED_BY | NUMBER | 38 | 0 | ||||
RELEASED_DATE | DATE | ||||||
REMIT_TO_ADDRESS_ID | NUMBER | 38 | 0 | ||||
REMIT_TO_ADDRESS_NAME | VARCHAR2 | 256 | |||||
REMIT_TO_SUPPLIER_ID | NUMBER | 38 | 0 | ||||
REMIT_TO_SUPPLIER_NAME | VARCHAR2 | 256 | |||||
REQUEST_ID | NUMBER | 38 | 0 | ||||
SETTLEMENT_PRIORITY | VARCHAR2 | 32 | |||||
STAMP_DUTY_AMT | NUMBER | ||||||
STAMP_DUTY_BASE_AMT | NUMBER | ||||||
STATE | VARCHAR2 | 256 | |||||
STATUS_LOOKUPCODE | VARCHAR2 | 32 | |||||
STOPPED_BY | NUMBER | 38 | 0 | ||||
STOPPED_DATE | DATE | ||||||
TRANSFER_PRIORITY | VARCHAR2 | 32 | |||||
TREASURY_PAY_DATE | DATE | ||||||
TREASURY_PAY_NUMBER | NUMBER | 38 | 0 | ||||
USSGLTRANSACTION_CODE | VARCHAR2 | 32 | |||||
USSGLTRXCODECON_TEXT | VARCHAR2 | 32 | |||||
VENDOR_ID | NUMBER | 38 | 0 | ||||
VENDOR_NAME | VARCHAR2 | 256 | |||||
VENDOR_SITE_CODE | VARCHAR2 | 16 | |||||
VENDOR_SITE_ID | NUMBER | 38 | 0 | ||||
VOID_DATE | DATE | ||||||
XCURR_RATE_TYPE | VARCHAR2 | 32 | |||||
ZIP | VARCHAR2 | 64 |