AR_INV_API_HEADERS_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRX_HEADER_ID | NUMBER | Oracle internal use only | |||
| TRX_NUMBER | VARCHAR2 | 30 | Oracle internal use only | ||
| TRX_DATE | DATE | Oracle internal use only | |||
| TRX_CURRENCY | VARCHAR2 | 30 | Oracle internal use only | ||
| REFERENCE_NUMBER | VARCHAR2 | 30 | Oracle internal use only | ||
| TRX_CLASS | VARCHAR2 | 20 | Oracle internal use only | ||
| CUST_TRX_TYPE_SEQ_ID | NUMBER | Oracle internal use only | |||
| GL_DATE | DATE | Oracle internal use only | |||
| BILL_TO_CUSTOMER_ID | NUMBER | Oracle internal use only | |||
| BILL_TO_ACCOUNT_NUMBER | VARCHAR2 | 30 | Oracle internal use only | ||
| BILL_TO_CUSTOMER_NAME | VARCHAR2 | 260 | Oracle internal use only | ||
| BILL_TO_CONTACT_ID | NUMBER | Oracle internal use only | |||
| BILL_TO_ADDRESS_ID | NUMBER | Oracle internal use only | |||
| BILL_TO_SITE_USE_ID | NUMBER | Oracle internal use only | |||
| SHIP_TO_CUSTOMER_ID | NUMBER | Oracle internal use only | |||
| SHIP_TO_ACCOUNT_NUMBER | VARCHAR2 | 30 | Oracle internal use only | ||
| SHIP_TO_CUSTOMER_NAME | VARCHAR2 | 260 | Oracle internal use only | ||
| SHIP_TO_CONTACT_ID | NUMBER | Oracle internal use only | |||
| SHIP_TO_ADDRESS_ID | NUMBER | Oracle internal use only | |||
| SHIP_TO_SITE_USE_ID | NUMBER | Oracle internal use only | |||
| SOLD_TO_CUSTOMER_ID | NUMBER | Oracle internal use only | |||
| TERM_ID | NUMBER | Oracle internal use only | |||
| PRIMARY_SALESREP_ID | NUMBER | Oracle internal use only | |||
| PRIMARY_SALESREP_NAME | VARCHAR2 | 240 | Oracle internal use only | ||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 60 | Oracle internal use only | ||
| EXCHANGE_DATE | DATE | Oracle internal use only | |||
| EXCHANGE_RATE | NUMBER | Oracle internal use only | |||
| TERRITORY_ID | NUMBER | Oracle internal use only | |||
| REMIT_TO_ADDRESS_ID | NUMBER | Oracle internal use only | |||
| INVOICING_RULE_ID | NUMBER | Oracle internal use only | |||
| PRINTING_OPTION | VARCHAR2 | 20 | Oracle internal use only | ||
| PURCHASE_ORDER | VARCHAR2 | 50 | Oracle internal use only | ||
| PURCHASE_ORDER_REVISION | VARCHAR2 | 50 | Oracle internal use only | ||
| PURCHASE_ORDER_DATE | DATE | Oracle internal use only | |||
| COMMENTS | VARCHAR2 | 240 | Oracle internal use only | ||
| INTERNAL_NOTES | VARCHAR2 | 240 | Oracle internal use only | ||
| FINANCE_CHARGES | VARCHAR2 | 1 | Oracle internal use only | ||
| RECEIPT_METHOD_ID | NUMBER | Oracle internal use only | |||
| RELATED_CUSTOMER_TRX_ID | NUMBER | Oracle internal use only | |||
| AGREEMENT_ID | NUMBER | Oracle internal use only | |||
| STATUS_TRX | VARCHAR2 | 30 | Oracle internal use only | ||
| PAYING_CUSTOMER_ID | NUMBER | Oracle internal use only | |||
| PAYING_SITE_USE_ID | NUMBER | Oracle internal use only | |||
| DEFAULT_TAX_EXEMPT_FLAG | VARCHAR2 | 1 | Oracle internal use only | ||
| DOC_SEQUENCE_VALUE | NUMBER | 18 | Oracle internal use only | ||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| LEGAL_ENTITY_ID | NUMBER | Oracle internal use only |