PAEXTR
tableFINPAEXTR
PAEXTR — FIN table in the standard Ross ERP 8.0 schema: 56 columns. Columns, data types, keys, foreign keys and relationships.
Open PAEXTR in the interactive Data Dictionary →Part of Other tables & objects · all tables, views & procedures
Columns
| # | Column | Type | Key | Description |
|---|---|---|---|---|
| 1 | GEM_DBKEY | int | GEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one. | |
| 2 | COMPANY_CODE | varchar(10) | Company Code | |
| 3 | AP_DIVISION | varchar(2) | Division | |
| 4 | PAEXTR_VENDOR_ID | varchar(12) | ||
| 5 | PAEXTR_PAYABLE_ID | varchar(20) | ||
| 6 | PAEXTR_ORIG_ENTRY_DATE | varchar(8) | ||
| 7 | PAEXTR_ORIG_ENTRY_TIME | varchar(4) | ||
| 8 | PAEXTR_UPDATE_OPERATOR | varchar(12) | ||
| 9 | PAEXTR_PAYABLE_CLASS | varchar(1) | ||
| 10 | PAEXTR_SEPARATE_CHECK | varchar(1) | ||
| 11 | PAEXTR_PAYABLE_REF | varchar(15) | ||
| 12 | PAEXTR_PAYABLE_COMMENT | varchar(30) | ||
| 13 | PAEXTR_DISC_TERMS_CODE | varchar(6) | ||
| 14 | PAEXTR_REMIT_ID | varchar(12) | ||
| 15 | PAEXTR_BATCH_ID | varchar(10) | ||
| 16 | PAEXTR_PO_NUMBER | varchar(20) | ||
| 17 | PAEXTR_BANK_ID | varchar(6) | ||
| 18 | PAEXTR_GL_LIAB_ACCT_NBR | varchar(50) | ||
| 19 | PAEXTR_GL_CASH_ACCT_NBR | varchar(50) | ||
| 20 | PAEXTR_DISC_TAKEN_ACCT | varchar(50) | ||
| 21 | PAEXTR_ENTRY_DATE | varchar(8) | ||
| 22 | PAEXTR_DUE_DATE | varchar(8) | ||
| 23 | PAEXTR_DISCOUNT_DATE | varchar(8) | ||
| 24 | PAEXTR_GROSS_AMT | varchar(15) | ||
| 25 | PAEXTR_DISC_BASE_AMT | varchar(15) | ||
| 26 | PAEXTR_DISC_AMT | varchar(15) | ||
| 27 | PAEXTR_BASE_CURR_CODE | varchar(6) | ||
| 28 | PAEXTR_RATE_TYPE | varchar(6) | ||
| 29 | PAEXTR_RATE_AUTHORITY | varchar(6) | ||
| 30 | PAEXTR_CURRENCY_CODE | varchar(6) | ||
| 31 | PAEXTR_CURRENCY_RATE | varchar(18) | ||
| 32 | PAEXTR_1099_RTN_TYPE | varchar(1) | ||
| 33 | PAEXTR_1099_AMT_TYPE | varchar(1) | ||
| 34 | PAEXTR_LEDGER | varchar(10) | ||
| 35 | PAEXTR_ENTITY | varchar(4) | ||
| 36 | PAEXTR_ACCT_YEAR | varchar(4) | ||
| 37 | PAEXTR_ACCT_PERIOD | varchar(2) | ||
| 38 | PDEXTR_DISTRIB_SEQ_NBR | varchar(3) | ||
| 39 | PDEXTR_DISTRIB_SEQ_CHAR | varchar(1) | ||
| 40 | PDEXTR_GL_EXPN_ACCT_NBR | varchar(50) | ||
| 41 | PDEXTR_DIST_ACCT_YR | varchar(4) | ||
| 42 | PDEXTR_DIST_ACCT_PERIOD | varchar(2) | ||
| 43 | PDEXTR_LINE_TYPE | varchar(1) | ||
| 44 | PDEXTR_ITEM_DESCR | varchar(30) | ||
| 45 | PDEXTR_1099_ITEM | varchar(1) | ||
| 46 | PDEXTR_USE_TAX_CODE | varchar(5) | ||
| 47 | PDEXTR_DISTRIB_AMT | varchar(15) | ||
| 48 | PDEXTR_BASE_DISTRIB_AMT | varchar(15) | ||
| 49 | PDEXTR_ALT_TAX_CODE | varchar(2) | ||
| 50 | USERNAME | varchar(20) | Username | |
| 51 | SEQUENCE | smallint | Sequence Number | |
| 52 | STATUS | varchar(1) | Status | |
| 53 | STATUS_FLAG | varchar(1) | Status Flag | |
| 54 | BATCH_NUMBER | int | Run Number | |
| 55 | TAX | numeric(20,2) | Transaction Tax | |
| 56 | PDEXTR_GL_EXPN_SHORT_CODE | varchar(6) |