| 1 |
API_INVOICE_ID |
BIGINT |
8 |
| 2 |
API_INVOICE_NUM |
CHARACTER VARYING(50) |
50 |
| 3 |
API_VENDOR_ID |
BIGINT |
8 |
| 4 |
API_VENDOR_SITE_ID |
BIGINT |
8 |
| 5 |
APS_VENDOR_ID |
BIGINT |
8 |
| 6 |
API_AMOUNT_PAID |
NUMERIC(18,2) |
19 |
| 7 |
API_INVOICE_AMOUNT |
NUMERIC(18,2) |
19 |
| 8 |
APS_VENDOR_NAME |
CHARACTER VARYING(240) |
240 |
| 9 |
APSS_VENDOR_SITE_ID |
BIGINT |
8 |
| 10 |
APSS_VENDOR_ADDRESS |
CHARACTER VARYING(1524) |
1524 |
| 11 |
APSS_CITY |
CHARACTER VARYING(60) |
60 |
| 12 |
APSS_STATE |
CHARACTER VARYING(150) |
150 |
| 13 |
APSS_ZIP |
CHARACTER VARYING(60) |
60 |
| 14 |
APSS_COUNTRY |
CHARACTER VARYING(60) |
60 |
| 15 |
APSS_AREA_CODE |
CHARACTER VARYING(10) |
10 |
| 16 |
APSS_PHONE |
CHARACTER VARYING(15) |
15 |
| 17 |
APSS_EMAIL_ADDRESS |
CHARACTER VARYING(1000) |
1000 |
| 18 |
APSS_FAX |
CHARACTER VARYING(15) |
15 |
| 19 |
APSS_DUNS_NUMBER |
CHARACTER VARYING(30) |
30 |
| 20 |
APSS_VENDOR_SITE_CODE |
CHARACTER VARYING(15) |
15 |
| 21 |
APS_ABN |
CHARACTER VARYING(20) |
20 |
| 22 |
APS_SUPPLIER_NUM |
CHARACTER VARYING(30) |
30 |
| 23 |
APS_VENDOR_TYPE_LOOKUP_CODE |
CHARACTER VARYING(30) |
30 |
| 24 |
APS_PAYMENT_METHOD_LOOKUP_CODE |
CHARACTER VARYING(25) |
25 |
| 25 |
PAID_DATE |
TIMESTAMP |
8 |
| 26 |
API_DESCRIPTION |
CHARACTER VARYING(240) |
240 |
| 27 |
API_ATTRIBUTE6 |
CHARACTER VARYING(150) |
150 |
| 28 |
API_ATTRIBUTE9 |
CHARACTER VARYING(150) |
150 |
| 29 |
API_ATTRIBUTE12 |
CHARACTER VARYING(150) |
150 |
| 30 |
API_ATT12_6_CONCAT |
CHARACTER VARYING(301) |
301 |
| 31 |
API_CLAIM_INV_CNT |
BIGINT |
8 |
| 32 |
API_INVOICE_DATE |
TIMESTAMP |
8 |
| 33 |
DIST_QUANTITY_INVOICED |
NUMERIC(18,2) |
19 |
| 34 |
API_INV_CURR |
CHARACTER VARYING(15) |
15 |
| 35 |
API_SOURCE |
CHARACTER VARYING(25) |
25 |
| 36 |
API_INV_TYPE |
CHARACTER VARYING(25) |
25 |
| 37 |
API_CREATION_DATE |
TIMESTAMP |
8 |
| 38 |
API_ORG_ID |
BIGINT |
8 |
| 39 |
ORG_NAME |
CHARACTER VARYING(240) |
240 |
| 40 |
API_GL_DATE |
TIMESTAMP |
8 |
| 41 |
DIST_ILINE_NUM |
NUMERIC(18,2) |
19 |
| 42 |
DISTRIBUTION_LINE_NUMBER |
BIGINT |
8 |
| 43 |
DIST_BASE_AMOUNT |
NUMERIC(18,2) |
19 |
| 44 |
DIST_LINE_TYPE_LOOKUP_CODE |
CHARACTER VARYING(25) |
25 |
| 45 |
DIST_AMOUNT |
NUMERIC(18,2) |
19 |
| 46 |
INVOICE_DISTRIBUTION_ID |
BIGINT |
8 |
| 47 |
DIST_EVENT_ID |
BIGINT |
8 |
| 48 |
DIST_ACCOUNTING_DATE |
TIMESTAMP |
8 |
| 49 |
DIST_INV_IDX |
BIGINT |
8 |
| 50 |
DIST_INV_CNT |
BIGINT |
8 |
| 51 |
DIST_INV_DESC |
CHARACTER VARYING(240) |
240 |
| 52 |
GL_ENTITY_CODE |
CHARACTER VARYING(25) |
25 |
| 53 |
GL_ENTITY_NAME |
CHARACTER VARYING(240) |
240 |
| 54 |
COST_CENTRE_CODE |
CHARACTER VARYING(25) |
25 |
| 55 |
ACCOUNT_CODE |
CHARACTER VARYING(25) |
25 |
| 56 |
AP_PAYMENT_TERMS |
CHARACTER VARYING(240) |
240 |