BI_GTA_INV_LINE(SQL Table) |
Index Back |
---|---|
GTA Adapter Line TableUsed 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 |