BI_GT_INV_H_IMP

(SQL Table)
 Index Back

GT VAT Invoice Header Import

GT VAT Invoice Header Import, owned by SOS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INV_CAT_CD Character(10) VARCHAR2(10) NOT NULL Used by GTA
2 VAT_INVOICE_TYPE Character(1) VARCHAR2(1) NOT NULL VAT Invoice Type, used by Golden Tax Adapter, created by SOS
C=Common
S=Special
3 GT_INVOICE Character(8) VARCHAR2(8) NOT NULL Used by GTA
4 GTA_INVOICE Character(20) VARCHAR2(20) NOT NULL Invoice
5 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number
6 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
7 INVOICE_DT Date(10) DATE NOT NULL Invoice Date
8 TOTAL_LINES Number(4,0) SMALLINT NOT NULL SpeedChart Total Lines
9 GTA_CANCEL_FLG Character(1) VARCHAR2(1) NOT NULL Used by GTA
N=No
Y=Yes
10 FLAG Character(1) VARCHAR2(1) NOT NULL Flag
N=No
Y=Yes
11 GTA_MAP_FLG Character(1) VARCHAR2(1) NOT NULL Used by GTA
N=No
Y=Yes
12 GTA_MATCHED_FLG Character(1) VARCHAR2(1) NOT NULL Used by GTA
N=No
Y=Yes
13 GTA_SALES_FLG Character(1) VARCHAR2(1) NOT NULL Used by GTA
N=No
Y=Yes
14 GTA_REVIEWED_FLG Character(1) VARCHAR2(1) NOT NULL Used by GTA
N=No
Y=Yes
15 MONTH Character(2) VARCHAR2(2) NOT NULL MONTH
16 NET_AMT_GTA Signed Number(18,2) DECIMAL(16,2) NOT NULL Used by GTA
17 TAX_RATE_GTA Signed Number(8,2) DECIMAL(6,2) NOT NULL Used by GTA
18 TAX_AMT_GTA Signed Number(18,2) DECIMAL(16,2) NOT NULL Used by GTA
19 BUYER_DESCR2 Character(100) VARCHAR2(100) NOT NULL Buyer Desc, used by GTA
20 VAT_RGSTRN_ID Character(20) VARCHAR2(20) NOT NULL VAT Registration ID
21 ADDRESS_PHONE Character(80) VARCHAR2(80) NOT NULL Used by GTA
22 BANK_ACCOUNT_INFO Character(80) VARCHAR2(80) NOT NULL Used by GTA
23 SELLER_NAME Character(100) VARCHAR2(100) NOT NULL Used by GTA
24 SEL_VAT_RGSTRN_ID Character(30) VARCHAR2(30) NOT NULL VAT Registration ID, used by GTA
25 ADDRESS_PHONE2 Character(80) VARCHAR2(80) NOT NULL Used by GTA
26 SEL_BNK_ACCNT_INFO Character(80) VARCHAR2(80) NOT NULL Used by GTA
27 MEMO Character(160) VARCHAR2(160) NOT NULL Used by GTA
28 BILLING_SPECIALIST Character(8) VARCHAR2(8) NOT NULL Billing Specialist
29 VERIFIER Character(8) VARCHAR2(8) NOT NULL Used by GTA
30 CASHIER Character(8) VARCHAR2(8) NOT NULL Used by GTA
31 MTCHX_STATUS_I Character(1) VARCHAR2(1) NOT NULL I Match Status
N=No
Y=Yes
32 CREATE_DTTM DateTime(26) TIMESTAMP Creation Datetime
33 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
34 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.
35 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update