BI_GTA_STG_HDR(SQL Table) |
Index Back |
|---|---|
GTA Staged Invoice HeaderUsed by GTA |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INVOICE |
Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 3 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer |
| 4 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 5 | BATCH_CODE | Character(10) | VARCHAR2(10) NOT NULL | used by GTA |
| 6 | INVOICE_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Invoice Type
ACR=Credit Bill ADJ=Adjustment Only bill ARB=Rebill Bill PRF=Pro Forma Invoice RAD=Regular bill with adjustments REG=Regular Bill |
| 7 | VAT_INVOICE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
VAT Invoice Type, used by Golden Tax Adapter, created by SOS
C=Common S=Special |
| 8 | INVOICE_DT | Date(10) | DATE NOT NULL | Invoice Date |
| 9 | ACCOUNTING_DT | Date(10) | DATE NOT NULL | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 10 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 11 | CONSOL_HDR | Character(1) | VARCHAR2(1) NOT NULL |
Consolidated Hdr?
N=No Y=Yes |
| 12 | CONSOL_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Specifies the Billing business unit associated with a consolidated bill. |
| 13 | CONSOL_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Specifies the invoice identifier associated with a consolidated bill. |
| 14 | ORIGINAL_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Original Invoice |
| 15 | PRIOR_ADJ_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Prior Adjustment Invoice |
| 16 | NEXT_ADJ_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Next Adjustment Invoice |
| 17 | LATEST_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Latest Invoice |
| 18 | BILL_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL | Bill Type Identifier |
| 19 | BILL_SOURCE_ID | Character(10) | VARCHAR2(10) NOT NULL | Bill Source |
| 20 | VAT_RGSTRN_ID | Character(20) | VARCHAR2(20) NOT NULL |
VAT Registration ID
Prompt Table: GTA_CU_VAT_RGVW |
| 21 | VAT_RGSTRN_ID2 | Character(30) | VARCHAR2(30) NOT NULL | VAT Registration ID, this is a new created field for GTA. |
| 22 | BUYER_DESCR2 | Character(100) | VARCHAR2(100) NOT NULL | Buyer Desc, used by GTA |
| 23 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
| 24 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 25 | PHONE5 | Character(33) | VARCHAR2(33) NOT NULL | Used by GTA |
| 26 | ADDRESS_PHONE | Character(80) | VARCHAR2(80) NOT NULL | Used by GTA |
| 27 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 28 | BANK_ACCT_KEY | Character(4) | VARCHAR2(4) NOT NULL | A user defined unique identifier that facilitates the identification of a given account with a given bank |
| 29 | BANK_ACCOUNT_NAME | Character(60) | VARCHAR2(60) NOT NULL | Used by Golden Tax Adapter, created by SOS |
| 30 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 31 | BANK_ACCOUNT_INFO | Character(80) | VARCHAR2(80) NOT NULL | Used by GTA |
| 32 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 33 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " |
| 34 | CURRENCY_CNY | Character(3) | VARCHAR2(3) NOT NULL | Used by Golden Tax Adapter |
| 35 | INVOICE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount |
| 36 | INVOICE_AMOUNT_CNY | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount |
| 37 | INVOICE_AMOUNT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount in Base Currency |
| 38 | INVOICE_AMT_PRETAX | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Pretax Invoice Amount |
| 39 | INVOICE_PRETAX_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Pretax Invoice Amount Base |
| 40 | TOT_VAT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total VAT Amount |
| 41 | TOT_VAT_CNY | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total VAT Amount |
| 42 | TOT_VAT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total VAT Amount Base |
| 43 | TOT_PRO_DSCNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Used by GTA |
| 44 | TOT_PRO_DSCNT_CNY | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Used by GTA |
| 45 | TOT_PRO_DSCNT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Used by GTA |
| 46 | BILLING_SPECIALIST | Character(8) | VARCHAR2(8) NOT NULL | Billing Specialist |
| 47 | SALES_LIST_FLG | Character(1) | VARCHAR2(1) NOT NULL |
GTA - Sales List Flag
N=No Y=Yes Default Value: N |
| 48 | GOODS_NAME | Character(60) | VARCHAR2(60) NOT NULL | Only used by GTA |
| 49 | MEMO | Character(160) | VARCHAR2(160) NOT NULL | Used by GTA |
| 50 | GTA_STG_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Used by GTA
CAL=Canceled ERR=Error GEN=Generated IGN=Ignored PRO=Prorated RDY=Ready REJ=Rejected TRS=Transferred Default Value: TRS |
| 51 | ERRORS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Indicates errors were found
N=No Y=Yes Default Value: N |
| 52 | DSCNT_PRORATE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Prorate Discount |
| 53 | SEL_VAT_RGSTRN_ID | Character(30) | VARCHAR2(30) NOT NULL | VAT Registration ID, used by GTA |
| 54 | BANK_ACCOUNT_INFO2 | Character(80) | VARCHAR2(80) NOT NULL | Used by GTA |
| 55 | ADDRESS_PHONE2 | Character(80) | VARCHAR2(80) NOT NULL | Used by GTA |
| 56 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 57 | ENTERED_DTTM | DateTime(26) | TIMESTAMP | Entered Datetime |
| 58 | 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. |
| 59 | OPRID_LAST_UPDT | Character(30) | VARCHAR2(30) NOT NULL | Last User to Update |