CMR_AP_ERRORS_GT
Global temporary table (session) to store all the CIAID records which come with corrupt data from source system
Details
-
Schema: FUSION
-
Object owner: FUSION
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Comments |
---|---|---|---|---|
EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Identifier of the source system that owns the Invoice entity | |
EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Identifier of the Invoice in the source system | |
ERROR_CODE | VARCHAR2 | 30 | Error Message Code on the invoice distribution lines and these error code maps to FND_MESSAGES_B | |
BILL_TO_BUSINESS_UNIT_ID | NUMBER | 18 | Bill to business unit identifier. Indicates the invoicing business unit on purchase orders. | |
BUSINESS_UNIT_ID | NUMBER | 18 | Profit Center business unit of purchase order. | |
TOKEN_VALUE1 | VARCHAR2 | 240 | Token Value stored populated on error type of invoice distribution. | |
TOKEN_VALUE2 | VARCHAR2 | 240 | Token Value 2 -populated based on error type of invoice distribution. | |
TOKEN_VALUE3 | VARCHAR2 | 240 | Token Value 3 -populated based on error type of invoice distribution. |