BUSINESS_UNITPrompt Table: SP_BU_GTA_NONVW
Y/N Table Edit
Default Value: Y
C=Common
S=Special
Default Value: S
Prompt Table: BANK_CD_TBL
Prompt Table: BANK_BRANCH_TBL
Prompt Table: BANK_ACCT_DEFN
Y/N Table Edit
Default Value: Y
BI_GTA_GNR_OPTN(SQL Table) |
Index Back |
|---|---|
GTA SETUP GENERAL OPTIONSGTA SETUP GENERAL OPTIONS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_GTA_NONVW |
| 2 | SPLIT_LINE | Character(1) | VARCHAR2(1) NOT NULL |
Split Line
Y/N Table Edit Default Value: Y |
| 3 | VAT_INVOICE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
VAT Invoice Type, used by Golden Tax Adapter, created by SOS
C=Common S=Special Default Value: S |
| 4 | ADDRESS_PHONE | Character(80) | VARCHAR2(80) NOT NULL | Used by GTA |
| 5 | BNK_NAME_ACCNT_NUM | Character(80) | VARCHAR2(80) NOT NULL | Used by GTA |
| 6 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table: BANK_CD_TBL |
| 7 | BRANCH_NAME | Character(10) | VARCHAR2(10) NOT NULL |
Branch Name
Prompt Table: BANK_BRANCH_TBL |
| 8 | 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
Prompt Table: BANK_ACCT_DEFN |
| 9 | SPLIT_RATE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Multiple Tax Rates in One Invoice
Y/N Table Edit Default Value: Y |