BI_GTA_OTR_OPTN(SQL Table) |
Index Back |
---|---|
GTA SETUP OTHER OPTIONSGTA Set Up Other Options |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
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 | MAX_LINE_NUM_1 | Number(5,0) | INTEGER NOT NULL | Max Line Number |
4 | MAX_INV_AMT | Number(17,2) | DECIMAL(16,2) NOT NULL | Used by GTA |