PAYMENTS Table
View exposing payment detail for accounts payable disbursements including vendor, amount, bank, and processing attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCOUNTING_DOCUMENT_FY |
Accounting document fy associated with the record. |
VARCHAR2 |
4 |
ACCOUNTING_DOCUMENT_NUMBER |
Accounting document number associated with the record. |
VARCHAR2 |
10 |
ACCOUNT_ID |
Business identifier for the account. |
VARCHAR2 |
5 |
ADDITIONAL_IDENTIFICATION |
Additional identification associated with the record. |
VARCHAR2 |
6 |
AMOUNT_PAID |
Amount paid associated with the record. |
NUMBER |
17,2 |
ASSIGNMENT |
Assignment associated with the record. |
VARCHAR2 |
2 |
BANK_ACCOUNT_GL_ACCOUNT_KEY |
Surrogate key identifying the bank account gl account. |
VARCHAR2 |
10 |
CASH_DISCOUNT |
Cash discount associated with the record. |
NUMBER |
17,2 |
CHECK_ENCASHMENT_DATE |
Date associated with check encashment. |
DATE |
|
CHECK_NUMBER |
Check number associated with the record. |
VARCHAR2 |
13 |
CLEARING_REVERSED_INDICATOR |
Indicator identifying whether clearing reversed (Y/N). |
VARCHAR2 |
1 |
COMPANY_CODE |
Code identifying company. |
VARCHAR2 |
4 |
EXTRACT_CREATION_DATE |
Date associated with extract creation. |
DATE |
|
EXTRACT_CREATION_TIME |
Time associated with extract creation. |
VARCHAR2 |
6 |
FISCAL_YEAR |
Fiscal year associated with the record. |
VARCHAR2 |
4 |
FROM_CHECK_NUMBER |
From check number associated with the record. |
VARCHAR2 |
13 |
HOUSE_BANK |
House bank associated with the record. |
VARCHAR2 |
5 |
INFO |
Info associated with the record. |
VARCHAR2 |
1 |
IS_VOID_CHECK |
Indicator identifying whether void check (Y/N). |
VARCHAR2 |
1 |
MANUAL_CHECK_FLAG |
Indicator identifying whether manual check (Y/N). |
VARCHAR2 |
1 |
PAID_CHECK_FLAG |
Indicator identifying whether paid check (Y/N). |
VARCHAR2 |
1 |
PAYEE_CITY |
Payee city associated with the record. |
VARCHAR2 |
40 |
PAYEE_CODE |
Code identifying payee. |
VARCHAR2 |
20 |
PAYEE_COUNTRY_CODE |
Payee country code associated with the record. |
VARCHAR2 |
3 |
PAYEE_NAME_1 |
Payee name 1 associated with the person. |
VARCHAR2 |
40 |
PAYEE_NAME_2 |
Payee name 2 associated with the person. |
VARCHAR2 |
40 |
PAYEE_NAME_3 |
Payee name 3 associated with the person. |
VARCHAR2 |
40 |
PAYEE_NAME_4 |
Payee name 4 associated with the person. |
VARCHAR2 |
40 |
PAYEE_POSTAL_CODE |
Payee postal code associated with the record. |
VARCHAR2 |
10 |
PAYEE_PO_BOX |
Payee po box associated with the record. |
VARCHAR2 |
10 |
PAYEE_PO_BOX_CITY |
Payee po box city associated with the record. |
VARCHAR2 |
35 |
PAYEE_PO_BOX_POSTAL_CODE |
Payee po box postal code associated with the record. |
VARCHAR2 |
10 |
PAYEE_STATE |
Payee state associated with the record. |
VARCHAR2 |
3 |
PAYEE_STREET |
Payee street associated with the record. |
VARCHAR2 |
40 |
PAYEE_TITLE |
Payee title associated with the record. |
VARCHAR2 |
15 |
PAYMENT_DOCUMENT_NUMBER |
Payment document number associated with the record. |
VARCHAR2 |
10 |
PAYMENT_MEDIUM_TYPE |
Payment medium type associated with the record. |
VARCHAR2 |
1 |
PAYMENT_METHOD |
Payment method associated with the record. |
VARCHAR2 |
1 |
PAYMENT_METHOD_SUPPLEMENT |
Payment method supplement associated with the record. |
VARCHAR2 |
2 |
PERSONNEL_NUMBER |
Personnel number associated with the record. |
VARCHAR2 |
8 |
PRINT_DATE |
Date associated with print. |
DATE |
|
PRINT_TIME |
Time associated with print. |
VARCHAR2 |
6 |
PRINT_USER |
Print user associated with the record. |
VARCHAR2 |
12 |
PROBABLE_PAYMENT_DATE |
Date associated with probable payment. |
DATE |
|
REPLACEMENT_CHECK_ACCOUNT |
Replacement check account associated with the record. |
VARCHAR2 |
5 |
REPLACEMENT_CHECK_BANK |
Replacement check bank associated with the record. |
VARCHAR2 |
5 |
REPLACEMENT_CHECK_NUMBER |
Replacement check number associated with the record. |
VARCHAR2 |
13 |
RUN_DATE |
Date associated with run. |
DATE |
|
SEQUENCE_NUMBER |
Sequence number associated with the record. |
VARCHAR2 |
5 |
VENDOR_KEY |
Surrogate key identifying the vendor. |
VARCHAR2 |
11 |
VOID_CHECK_DATE |
Date associated with void check. |
DATE |
|
VOID_CHECK_REASON |
Void check reason associated with the record. |
VARCHAR2 |
50 |
VOID_CHECK_REASON_CODE |
Code identifying void check reason. |
VARCHAR2 |
2 |
VOID_CHECK_USER |
Void check user associated with the record. |
VARCHAR2 |
12 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |