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. |