BI_GTA_INV_LINE

(SQL Table)
Index Back

GTA Adapter Line Table

Used by GTA, Adapter Invoice line table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GTA_INVOICE Character(20) VARCHAR2(20) NOT NULL Invoice
2 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
5 LINE_SEQ_NUM2 Number(5,0) INTEGER NOT NULL Sequence
6 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
7 GOODS_NAME Character(60) VARCHAR2(60) NOT NULL Only used by GTA
8 UOM_GTA Character(16) VARCHAR2(16) NOT NULL Used by GTA
9 BI_MODEL Character(40) VARCHAR2(40) NOT NULL Used by Golden Tax Adapter, created by SOS
10 QUANTITY_GTA Signed Number(24,6) DECIMAL(22,6) NOT NULL Used by GTA
11 NET_AMT_GTA Signed Number(18,2) DECIMAL(16,2) NOT NULL Used by GTA
12 TAX_CD_VAT Character(8) VARCHAR2(8) NOT NULL Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
13 TAX_RATE_GTA Signed Number(8,2) DECIMAL(6,2) NOT NULL Used by GTA
14 TAX_DENOMINATION Character(4) VARCHAR2(4) NOT NULL New field for Golden Tax Adapter
15 DISCOUNT_AMT_GTA Signed Number(18,2) DECIMAL(16,2) NOT NULL Used by GTA
16 TAX_AMT_GTA Signed Number(18,2) DECIMAL(16,2) NOT NULL Used by GTA
17 DISCUNT_TAX_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Used by GTA
18 DISCOUNT_RATE Signed Number(11,3) DECIMAL(9,3) NOT NULL Used by GTA
19 UNIT_AMT_GTA Signed Number(24,6) DECIMAL(22,6) NOT NULL Used by GTA
20 TYPE Character(1) VARCHAR2(1) NOT NULL TYPE
21 GT_IDENTIFIER Character(12) VARCHAR2(12) NOT NULL New Field for Golden Tax Adapter
22 ERRORS_FLG Character(1) VARCHAR2(1) NOT NULL Indicates errors were found
N=No
Y=Yes
23 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
24 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
25 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
26 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update