IBY_AR_DOC_HEADER_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: FUSION
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CALLING_APP_DOC_REF_NUMBER | VARCHAR2 | 30 | The table is used in fund capture processing. Oracle internal use only. | ||
| DOCUMENT_DATE | DATE | Oracle internal use only. | |||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| DOCUMENT_TYPE | VARCHAR2 | 30 | Oracle internal use only. | ||
| DOCUMENT_DESCRIPTION | VARCHAR2 | 240 | Oracle internal use only. | ||
| DOCUMENT_AMOUNT | NUMBER | Oracle internal use only. | |||
| DOCUMENT_CURRENCY_CODE | VARCHAR2 | 15 | Oracle internal use only. | ||
| SETTLEMENT_AMOUNT | NUMBER | Oracle internal use only. | |||
| FREIGHT_AMOUNT | NUMBER | Oracle internal use only. | |||
| DISCOUNT_AMOUNT | NUMBER | Oracle internal use only. | |||
| LOCAL_TAX_AMOUNT | NUMBER | Oracle internal use only. | |||
| NATIONAL_TAX_AMOUNT | NUMBER | Oracle internal use only. | |||
| VAT_TAX_AMOUNT | NUMBER | Oracle internal use only. | |||
| ADDRESS1 | VARCHAR2 | 240 | Oracle internal use only. | ||
| ADDRESS2 | VARCHAR2 | 240 | Oracle internal use only. | ||
| ADDRESS3 | VARCHAR2 | 240 | Oracle internal use only. | ||
| CITY | VARCHAR2 | 60 | Oracle internal use only. | ||
| COUNTY | VARCHAR2 | 60 | Oracle internal use only. | ||
| STATE | VARCHAR2 | 60 | Oracle internal use only. | ||
| COUNTRY | VARCHAR2 | 60 | Oracle internal use only. | ||
| POSTAL_CODE | VARCHAR2 | 60 | Oracle internal use only. | ||
| TO_ADDRESS1 | VARCHAR2 | 240 | Oracle internal use only. | ||
| TO_ADDRESS2 | VARCHAR2 | 240 | Oracle internal use only. | ||
| TO_ADDRESS3 | VARCHAR2 | 240 | Oracle internal use only. | ||
| TO_CITY | VARCHAR2 | 60 | Oracle internal use only. | ||
| TO_COUNTY | VARCHAR2 | 60 | Oracle internal use only. | ||
| TO_STATE | VARCHAR2 | 60 | Oracle internal use only. | ||
| TO_COUNTRY | VARCHAR2 | 60 | Oracle internal use only. | ||
| TO_POSTAL_CODE | VARCHAR2 | 60 | Oracle internal use only. | ||
| DOC_UNIQUE_REF | NUMBER | 18 | Oracle internal use only. | ||
| CUST_PARTY_ID | NUMBER | 18 | Oracle internal use only. | ||
| CUST_PARTY_NUMBER | VARCHAR2 | 30 | Oracle internal use only. | ||
| CUST_PARTY_NAME | VARCHAR2 | 360 | Oracle internal use only. | ||
| CUST_PARTY_TYPE | VARCHAR2 | 30 | Oracle internal use only. | ||
| CUST_PARTY_TYPE_MEANING | VARCHAR2 | 80 | Oracle internal use only. | ||
| CUST_PARTY_ALT_NAME | VARCHAR2 | 360 | Oracle internal use only. | ||
| CUST_PARTY_ALT_FIRST_NAME | VARCHAR2 | 150 | Oracle internal use only. | ||
| CUST_PARTY_ALT_LAST_NAME | VARCHAR2 | 150 | Oracle internal use only. | ||
| CUST_ACCOUNT_NUMBER | VARCHAR2 | 30 | Oracle internal use only. | ||
| BILL_TO_ADDRESS_ID | NUMBER | 18 | Oracle internal use only. | ||
| BILL_TO_ADDRESS1 | VARCHAR2 | 240 | Oracle internal use only. | ||
| BILL_TO_ADDRESS2 | VARCHAR2 | 240 | Oracle internal use only. | ||
| BILL_TO_ADDRESS3 | VARCHAR2 | 240 | Oracle internal use only. | ||
| BILL_TO_CITY | VARCHAR2 | 60 | Oracle internal use only. | ||
| BILL_TO_COUNTY | VARCHAR2 | 60 | Oracle internal use only. | ||
| BILL_TO_STATE | VARCHAR2 | 60 | Oracle internal use only. | ||
| BILL_TO_COUNTRY | VARCHAR2 | 60 | Oracle internal use only. | ||
| BILL_TO_TERRITORY_SHORT_NAME | VARCHAR2 | 80 | Oracle internal use only. | ||
| BILL_TO_ISO_TERRITORY_CODE | VARCHAR2 | 3 | Oracle internal use only. | ||
| BILL_TO_POSTAL_CODE | VARCHAR2 | 60 | Oracle internal use only. | ||
| LEGAL_ENTITY_ID | NUMBER | 18 | Oracle internal use only. | ||
| LEGAL_REGISTRATION_NUMBER | VARCHAR2 | 30 | Oracle internal use only. | ||
| TAX_REGISTRATION_NUMBER | VARCHAR2 | 200 | Oracle internal use only. | ||
| ORDER_TANGIBLE_ID | VARCHAR2 | 80 | Oracle internal use only. | ||
| INITIATOR_EXTENSION_ID | NUMBER | 18 | Oracle internal use only. | ||
| INV_LEGAL_ENTITY_ID | NUMBER | 18 | Oracle internal use only. | ||
| INV_TAX_REGISTRATION_NUMBER | VARCHAR2 | 200 | Oracle internal use only. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| IBY_AR_DOC_HEADER_GT_N1 | Non Unique | INITIATOR_EXTENSION_ID |