BI_EXTRACT_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	TO_BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit selection field
4	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
5	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
6	PRIOR_INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
7	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
8	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
9	BILL_CYCLE_ID	Character(10)	VARCHAR2(10) NOT NULL	Billing Cycle Identifier
10	BILL_SOURCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill Source
11	BILL_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	Bill Type Identifier
12	RANGE_SELECTION_ID	Character(30)	VARCHAR2(30) NOT NULL	Range Selection ID
13	START_INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Starting Invoice Number
14	END_INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Ending Invoice Number
15	INVOICE_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Invoice Action C=Reprint I=Invoice P=Pro Forma
16	CONSOLIDATE	Character(1)	VARCHAR2(1) NOT NULL	Consolidate Headers
17	INVOICE_DT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Invoice Date Option P=Processing Date U=User Defined
18	INVOICE_DT	Date(10)	DATE	Invoice Date
19	PRT_ONLY_UNPRINTED	Character(1)	VARCHAR2(1) NOT NULL	Print Only Unprinted Invoices
20	PRT_ONLY_PRIMARY	Character(1)	VARCHAR2(1) NOT NULL	Print Only Primary Copy
21	PRINT_IND	Character(1)	VARCHAR2(1) NOT NULL	Include Print Suppressed Forms
22	PRT_CUST_LABEL	Character(1)	VARCHAR2(1) NOT NULL	Print with Customer Label
23	CUSTOM_LABEL	Character(20)	VARCHAR2(20) NOT NULL	Custom Label
24	PRT_INVOICE_SORT	Character(1)	VARCHAR2(1) NOT NULL	Print Invoice Sort By B=Bus Unit, Invoice C=Customer, Invoice P=Country, Postal
25	USE_CURRENT_ADDR	Character(1)	VARCHAR2(1) NOT NULL	Use Current Effective Address
26	BILL_TO_COPIES	Number(3,0)	SMALLINT NOT NULL	Number of Copies
27	PRINT_SEQ_NBR	Number(5,0)	INTEGER NOT NULL	Print Sequence
28	EDI_OPTION	Character(1)	VARCHAR2(1) NOT NULL	EDI Invoice Options 1=EDI Only 2=EDI and Print 3=Print Only
29	SUPPRESS_SUMM_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Field used to suppress the printing of Summary details on an Invoice that has been sent via Email to an Email ID from the Self Service Transactions.
30	INCL_ATTACHED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include Attached Bills
31	INCL_OPEN_ITEMS	Character(1)	VARCHAR2(1) NOT NULL	Include Open Items Only
32	STARTING_DT	Date(10)	DATE	Bills Added On or After
33	FROM_DUE_DT	Date(10)	DATE	From Due Date
34	TO_DUE_DT	Date(10)	DATE	To Due Date
35	INVOICE_DT_FROM	Date(10)	DATE	Invoice Date From
36	INVOICE_DT_TO	Date(10)	DATE	Through
37	REPRINT_GROUP_ID	Character(30)	VARCHAR2(30) NOT NULL	Reprint Group ID
38	SUM_IVC_PRINT_OPT	Character(4)	VARCHAR2(4) NOT NULL	Summarized Invoice Print Option BOTH=Print Both Summarized & Detail DETL=Print Detail SUM=Print Summarized
39	PRCSNAME	Character(12)	VARCHAR2(12) NOT NULL	Process Name
40	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
41	SQLTEXT	Long Character(14000)	CLOB	SQL Statement Text
42	AE_WHERE_1	Character(50)	VARCHAR2(50) NOT NULL	AE_WHERE_1
43	AE_WHERE_2	Character(50)	VARCHAR2(50) NOT NULL	AE_WHERE_2
44	AE_WHERE_3	Character(50)	VARCHAR2(50) NOT NULL	AE_WHERE_3
45	COUNTER	Number(10,0)	DECIMAL(10) NOT NULL	Counter
46	ROWCOUNTER1	Number(5,0)	INTEGER NOT NULL	Row(s) Selected
47	ROW_COUNT_NUM	Number(3,0)	SMALLINT NOT NULL	Number Rows
48	TEMP_FLD	Character(1)	VARCHAR2(1) NOT NULL	Temporary Field for App Engine
49	TMP_FLD	Character(1)	VARCHAR2(1) NOT NULL	Field for holding temp data
50	PRINT_SORT_BY	Character(60)	VARCHAR2(60) NOT NULL	Print Order By
51	PREVIOUS_LANG_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
52	REPORT_LANG_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
53	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
54	PREFERRED_LANGUAGE	Character(3)	VARCHAR2(3) NOT NULL	Preferred Language ARA=Arabic CFR=Canadian French CZE=Czech DAN=Danish DUT=Dutch E=English ENG=English ESP=Spanish F=French FIN=Finnish FRA=French GER=German HUN=Hungarian INE=International English ITA=Italian JPN=Japanese KOR=Korean NOR=Norwegian POL=Polish POR=Portuguese RUS=Russian SVE=Swedish THA=Thai UKE=UK English ZHS=Simplified Chinese ZHT=Traditional Chinese
55	LANGUAGE_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Language Option O=Specified Language R=Recipient's Language
56	BANK_NAME	Character(30)	VARCHAR2(30) NOT NULL	Bank Name
57	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
58	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
59	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
60	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
61	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
62	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
63	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
64	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
65	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
66	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
67	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
68	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat WW=Trailer
69	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
70	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
71	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
72	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
73	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: %EDIT_STATE
74	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
75	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
76	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
77	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
78	AMOUNT_XEU	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
79	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
80	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
81	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
82	ORIGINAL_INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Original Invoice
83	PRIOR_ADJ_INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Adjusted Invoice
84	ORIG_INVOICE_DT	Date(10)	DATE	Original Invoice Date. Used in BI_EXTRCT for adjustment invoices to hold the original invoice date.
85	PRIOR_INVOICE_DT	Date(10)	DATE	Prior Invoice Dt
86	VAT_ENTITY	Character(20)	VARCHAR2(20) NOT NULL	Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
87	VAT_CALC_GROSS_NET	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether VAT calculation should be done on the Gross (G) amount or on the Net (N) amount of sales or purchase transaction. When calculating VAT at net the early payment discount is applied to the goods amount before calculating the VAT. When calculating VAT at gross the VAT is initially calculated based on the gross transaction amount. G=Calculate at Gross N=Calculate at Net
88	VAT_DCLRTN_POINT	Character(1)	VARCHAR2(1) NOT NULL	A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment. A=At Accounting Date D=At Delivery Time I=At Invoice Time P=At Payment Time
89	VAT_EXCPTN_CERTIF	Character(20)	VARCHAR2(20) NOT NULL	Specifies the VAT exception certificate number. This identifier serves as proof of customer's exemption from VAT.
90	VAT_EXCPTN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	A flag that specifies the reason for a VAT exemption for a customer. Suspension (S) and Exoneration (X) are examples of Exception Type. N=None S=Suspended X=Exonerated
91	VAT_RGSTRN_BUYER	Character(20)	VARCHAR2(20) NOT NULL	Specifies a customers VAT Registration ID for a particular country.
92	VAT_RGSTRN_SELLER	Character(20)	VARCHAR2(20) NOT NULL	Seller's VAT Registration
93	CURRENCY_RPTG	Character(3)	VARCHAR2(3) NOT NULL	Reporting Currency
94	VAT_RPTG_CURR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Amounts in Reporting Currency
95	BUSINESS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Order Management Business Unit
96	PRODUCT_KIT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product Kit Number
97	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
98	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
99	SHIP_TO_ADDR_NUM	Number(5,0)	INTEGER NOT NULL	Ship To Address Sequence Num
100	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer
101	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
102	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
103	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
104	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
105	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
106	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
107	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
108	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
109	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
110	BUSINESS_UNIT_CA	Character(5)	VARCHAR2(5) NOT NULL	Contracts Business Unit
111	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
112	CONTRACT_PPD_SEQ	Number(5,0)	INTEGER NOT NULL	Prepaid Add Sequence
113	INSTALL_NBR	Number(3,0)	SMALLINT NOT NULL	Installment Number
114	INSTALLMENT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Installment Amount
115	GENERATED_INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Generated Invoice
116	NET_EXTENDED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Net Extended Amt
117	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
118	IDENTIFIER	Character(18)	VARCHAR2(18) NOT NULL	Identifier
119	TAX_CD	Character(8)	VARCHAR2(8) NOT NULL	Tax Code
120	STD_NOTE_CD	Character(10)	VARCHAR2(10) NOT NULL	Standard Note Code
121	NOTES_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Notes Sequence Num
122	NOTE_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Note Type
123	TEXT254	Character(254)	VARCHAR2(254) NOT NULL	Text
124	COUNTRY_VAT_BILLFR	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country where an invoice is generated (for VAT processing only).
125	COUNTRY_VAT_BILLTO	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country where an invoice is sent (for VAT processing only).
126	COUNTRY_2CHAR	Character(2)	VARCHAR2(2) NOT NULL	2-Char Country Code
127	ADD_DT	Date(10)	DATE	Customer Added On
128	LINE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Line Type 1 ADV=Advance Billing BAE=Billed Amount in Excess BRT=Billing Retainage DAPP=Cust Deposit Applied DEP=Customer Deposit DISC=Discount Line DREF=Cust Deposit Refunded DRFF=Cust Deposit Refund Fee FRGT=Freight (Surcharge) MISC=Miscellaneous Charge PYCV=Payment with Corporate Voucher RAE=Reclaimed Amount in Excess REV=Revenue Line RSTK=Restock (Surcharge) SUR=Surcharge Line UTL=Utilization Line
129	STRING_ID	Character(18)	VARCHAR2(18) NOT NULL	String ID
130	STRING_TEXT	Character(100)	VARCHAR2(100) NOT NULL	String Text
131	VAT_TREATMENT	Character(4)	VARCHAR2(4) NOT NULL	VAT Treatment
132	CONSOL_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Specifies the Billing business unit associated with a consolidated bill.
133	CONSOL_INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Specifies the invoice identifier associated with a consolidated bill.
134	STX_LST_RGSTN	Character(30)	VARCHAR2(30) NOT NULL	Local SalesTax Registration Number. It is allocated by the Sales Tax authority. The LST registration number should be captured for the vendor and customer at their location levels.
135	EXD_RGSTN_NBR	Character(15)	VARCHAR2(15) NOT NULL	Excise Registration Code. This field is unique to a particular Excise Tax Location.
136	STX_CST_RGSTN	Character(30)	VARCHAR2(30) NOT NULL	Central Sales Tax Registration Number. It is allocated by the Sales Tax authority. The CST registration number should be captured for the vendor and customer at their location levels.
137	INSTALL_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Installment Plan ID
138	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit
139	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
140	SHIP_FROM_BU	Character(5)	VARCHAR2(5) NOT NULL	Ship from INV BU
141	LANG_DESCR_OVR	Character(3)	VARCHAR2(3) NOT NULL	Language of Descr Override
142	TAX_AUTHORITY_CD	Character(3)	VARCHAR2(3) NOT NULL	Tax Authority
143	CR_CARD_DIGITS	Character(4)	VARCHAR2(4) NOT NULL	Card Number's Last Four Digits
144	CR_CARD_NBR	Character(44)	VARCHAR2(44) NOT NULL	"See OM
145	EMAIL_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Email Notification Options 1=Email Only 2=Email & Print 3=Print Only
146	DTTM_FROM	DateTime(26)	TIMESTAMP	From Date/Time
147	PRINT_ALIAS	Character(1)	VARCHAR2(1) NOT NULL	Print Alias Description Default Value: N
148	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
149	PROC_ONLINE	Character(1)	VARCHAR2(1) NOT NULL	Process Online
150	START_PVN	Number(6,0)	INTEGER NOT NULL	Starting Public Voucher Number
151	END_PVN	Number(6,0)	INTEGER NOT NULL	Ending Public Voucher Number
152	PUBLIC_VOUCHER_NBR	Number(6,0)	INTEGER NOT NULL	Public Voucher Number
153	PVN_GEN_LVL	Character(2)	VARCHAR2(2) NOT NULL	PVN Generation Level field used to store the Level on which a Public Voucher needs to be generated for a contract C=Contract Number CL=Contract Number/Contract Line CP=Contract Number/Project
154	INVOICE_RANGE_OPT	Character(3)	VARCHAR2(3) NOT NULL	Invoice Range Option ALI=All Invoiced Bills ALL=All CUS=Cust ID CYC=Bill Cycle DT=Date Bill Added DTI=Date GRP=Copy Group ID INV=Invoice ID MUL=Multi-Select Table PVN=Public Voucher Number RGP=Reprint Group SEL=Range ID SHP=Ship ID SRC=Bill Source TYP=Bill Type
155	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
156	GRP_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Group Line Number
157	GROUP_BY_TEXT	Character(254)	VARCHAR2(254) NOT NULL	Group by text
158	SQL_TEXT	Character(254)	VARCHAR2(254) NOT NULL	SQL Text
159	SQL_WHERE_001	Character(254)	VARCHAR2(254) NOT NULL
160	SQL_WHERE_002	Character(254)	VARCHAR2(254) NOT NULL
161	INVOICE2	Character(22)	VARCHAR2(22) NOT NULL	Invoice
162	LINE_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Sequence
163	BUS_UNIT_PC_WRK	Character(5)	VARCHAR2(5) NOT NULL	Created for MTE 8.8
164	GROSS_EXTENDED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Extended
165	TAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Amount
166	TOT_DISCOUNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Amt
167	TOT_SURCHARGE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Surcharge Amt
168	SAVED_GRP_LINE	Number(5,0)	INTEGER NOT NULL	Group Line Number
169	PVN_REBILL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Print Public Voucher as Rebill
170	PVN_PRINTED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Public Voucher Printed
171	ADDR_LN1	Character(55)	VARCHAR2(55) NOT NULL	Address Line 1
172	ADDR_LN2	Character(55)	VARCHAR2(55) NOT NULL	Address Line 2
173	ADDR_LN3	Character(55)	VARCHAR2(55) NOT NULL	Address Line 3
174	ADDR_LN4	Character(55)	VARCHAR2(55) NOT NULL	Address Line 4
175	ADDR_LN5	Character(80)	VARCHAR2(80) NOT NULL	Address Line 5
176	ADDR_LN6	Character(80)	VARCHAR2(80) NOT NULL	Address Line 6
177	ADDR_LN7	Character(55)	VARCHAR2(55) NOT NULL	Address Line 7
178	ADDR_LN8	Character(55)	VARCHAR2(55) NOT NULL	Address Line 8
179	COPY_COUNTER	Number(3,0)	SMALLINT NOT NULL	Copy Counter
180	EMAIL_IVC_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Email Invoice Options 1=Email Only 2=Email & Print 3=Print Only
181	VAT_AUTHORITY	Character(30)	VARCHAR2(30) NOT NULL	VAT Authority Name
182	DESCR_SHORT	Character(15)	VARCHAR2(15) NOT NULL	Short Name
183	TOT_VAT_RVC	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total VAT Amount
184	TOT_VAT_RVC_XEU	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total VAT Reverse Charge Amt
185	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
186	CURRENCY_CD_XEU	Character(3)	VARCHAR2(3) NOT NULL	Euro Currency
187	BI_BU_TAX_IND	Character(1)	VARCHAR2(1) NOT NULL	Billing Business Unit Tax Flag 0=PS standard taxes/VAT 1=Third-party tax supplier 2=India taxes
188	GST_FLG	Character(1)	VARCHAR2(1) NOT NULL	Enable Goods and Services Tax
189	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
190	BI_REV_CHRG_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Reverse Charge Amount
191	GST_RGSTN_NBR	Character(30)	VARCHAR2(30) NOT NULL	GST Registration Number
192	GST_RGSTN_NBR_1	Character(30)	VARCHAR2(30) NOT NULL	GST Registration Number
193	GST_RGSTN_NBR_2	Character(30)	VARCHAR2(30) NOT NULL	GST Registration Number
194	VAT_TXN_TYPE_CD	Character(4)	VARCHAR2(4) NOT NULL	Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.