BI_GT_IDNTIFIER

(SQL Table)
Index Back

Golden Tax Identifier

Golden Tax Identifier, used by Golden Tax Adapter, created by SOS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GT_IDENTIFIER Character(12) VARCHAR2(12) NOT NULL New Field for Golden Tax Adapter
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

3 IDENTIFIER_TYPE Character(1) VARCHAR2(1) NOT NULL New field for Golden Tax Adapter
N=No
Y=Yes
4 IDENTIFIER_TBL Character(3) VARCHAR2(3) NOT NULL Table Identifier
A=Asset ID
CON=Contracts
D=Discount Table
G=Generic Identifier
ID=PS/Billing Charge Id
ITM=PS/Inventory Item ID
LAB=Labor type
PDA=Product Alias
PRD=PS/Product Id
PRM=PS/Promotion Code
S=Surcharge Table
SVC=Service
UPC=UPC
UPN=Universal Item ID
5 BI_IDENTIFIER Character(20) VARCHAR2(20) NOT NULL Used by Golden Tax Adapter, created by SOS

Prompt Table: %EDITTABLE

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 TAX_DENOMINATION Character(4) VARCHAR2(4) NOT NULL New field for Golden Tax Adapter

Prompt Table: BI_GTA_TX_DE_VW

8 BI_MODEL Character(40) VARCHAR2(40) NOT NULL Used by Golden Tax Adapter, created by SOS
9 SHORT_CODE Character(4) VARCHAR2(4) NOT NULL Short Code, used by Golden Tax Adapter, created by SOS
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_VW

11 LAST_MODIFIED_DATE DateTime(26) TIMESTAMP Last modified date
12 EXPORT_STATUS_GTA Character(1) VARCHAR2(1) NOT NULL Export Status, used by Golden Tax Adapter, created by SOS

Default Value: N