JA_CN_VAT_MAPPING_GT
This Temporary table is used for VAT Mapping Report.
Details
-
Schema: FUSION
-
Object owner: JA
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Comments |
---|---|---|---|
GROUPNUM | NUMBER | Group Number.Oracle internal use only. | |
SOURCE | VARCHAR2 | 3 | Source.Oracle internal use only. |
INVOICE_NUM | VARCHAR2 | 30 | Invoice Number.Oracle internal use only. |
AR_TRX_SOURCE | VARCHAR2 | 30 | Receivables transaction source.Oracle internal use only. |
AR_TRX_CLASS | VARCHAR2 | 30 | Receivables transaction class.Oracle internal use only. |
INV_DATE | DATE | Invoice date.Oracle internal use only. | |
CUSTOMER_NAME | VARCHAR2 | 360 | Customer name.Oracle internal use only. |
AMOUNT | NUMBER | Amount.Oracle internal use only. | |
TAX_AMOUNT | NUMBER | Tax amount.Oracle internal use only. | |
TOTAL_AMOUNT | NUMBER | Total amount.Oracle internal use only. | |
AR_WARNING_MESSAGE | VARCHAR2 | 300 | Receivables warning message.Oracle internal use only. |
VAT_WARNING_MESSAGE | VARCHAR2 | 300 | Vat warning message.Oracle internal use only. |
VAT_TRX_HEADER_ID | NUMBER | Vat transaction header identifier.Oracle internal use only. |