VAT_CALC_TSTHDR(SQL Table) |
Index Back |
---|---|
VAT Calc Test Header |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
2 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
3 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
4 | INVOICE_DT | Date(10) | DATE |
Invoice Date
Default Value: %date |
5 | DSCNT_PCT | Number(7,3) | DECIMAL(6,3) NOT NULL | Discount Percentage |
6 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
7 | VAT_CALC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
"A flag that indicates how VAT is stated and determines how the system performs the relevant VAT calculations. If ""Exclusive"", the VAT amount is stated separately from the merchandise amount. If ""Inclusive"", the VAT is not stated separately but is included with the merchandise amount."
E=Exclusive I=Inclusive |
8 | VAT_CALC_GROSS_NET | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether VAT calculation should be done on the Gross (G) amount or on the Net (N) amount of sales or purchase transaction. When calculating VAT at net the early payment discount is applied to the goods amount before calculating the VAT. When calculating VAT at gross the VAT is initially calculated based on the gross transaction amount.
G=Calculate at Gross N=Calculate at Net |
9 | VAT_RECALC_FLG | Character(1) | VARCHAR2(1) NOT NULL | A flag that indicates whether or not the VAT discount amount is recalculated at payment time. This field is only used if the VAT Calculation Type (VAT_CAL_GROSS_NET) is gross. |
10 | VAT_CALC_FRGHT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Include Freight |
11 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table: RT_TYPE_TBL |