GST_TXN_TBL_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	GST_DOC_ID	Character(22)	VARCHAR2(22) NOT NULL	Field to Store Application specific Document ID's for GST Transaction Table
6	ORG_SETID	Character(5)	VARCHAR2(5) NOT NULL	Organization SetID.
7	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
8	GST_SOURCE_DEFN	Character(10)	VARCHAR2(10) NOT NULL	Update GST Source Definition
9	ORG_CODE	Character(6)	VARCHAR2(6) NOT NULL	Organization Code. This will be unique to an Organization.
10	EXS_TAX_TXN_TYPE1	Character(4)	VARCHAR2(4) NOT NULL	Tax Transaction Type. This field will be used in the Tax determination and calculation of taxes.
11	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
12	EXS_TAX_TYPE1	Character(1)	VARCHAR2(1) NOT NULL	Tax Type
13	PHYSICAL_NATURE1	Character(1)	VARCHAR2(1) NOT NULL	Physical Nature
14	ORG_BU_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Business Unit Type. This field will have six translate values representing the various BUs AP=Payables AR=Receivables BI=Billing IN=Inventory OM=Order Management PO=Purchasing
15	STX_APPL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Sales Tax Applicability. Y/N Table Edit Default Value: N
16	STX_CUST_CATG_CD	Character(10)	VARCHAR2(10) NOT NULL	Sales Customer Category Code
17	INVOICE_TYPE1	Character(3)	VARCHAR2(3) NOT NULL	Invoice Type
18	ENTRY_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction.
19	INVOICE_DT	Date(10)	DATE	Invoice Date
20	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.
21	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
22	STX_TAX_AUTH_CD	Character(8)	VARCHAR2(8) NOT NULL	Tax Authority Code
23	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
24	STX_ITM_CATG_CD	Character(10)	VARCHAR2(10) NOT NULL	Sales Item Category Code
25	COUNTRY_SHIP_TO	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country to which the invoice contents were shipped (for VAT processing only).
26	COUNTRY_SHIP_FROM	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country from which the invoice contents were shipped (for VAT processing only).
27	STATE_SHIP_TO	Character(6)	VARCHAR2(6) NOT NULL	Ship To State
28	STATE_SHIP_FROM	Character(6)	VARCHAR2(6) NOT NULL	Ship From State
29	EXS_CURRENCY_RPTG	Character(3)	VARCHAR2(3) NOT NULL	Excise Currency Reporting
30	ORIGINAL_INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Original Invoice
31	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
32	VOUCHER_TYPE1	Character(1)	VARCHAR2(1) NOT NULL	Voucher Type
33	EXS_TAX_RATE_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Rate Code
34	EXS_TAX_CMPNT_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Component Code
35	EXS_TAX_RATE_PCT	Number(8,4)	DECIMAL(7,4) NOT NULL	Tax Rate Percentage
36	EXS_TAXRT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Rate Amount
37	EXS_TAXRT_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Rate Amount
38	EXS_TAXRT_AMT_RPT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Rate Amount
39	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. "
40	EXS_TAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Sales Tax Amount
41	EXS_TAX_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Sales Tax Amount Base Currency
42	EXS_TAX_AMT_RPT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Sales Tax Amount Reporting Currency
43	EXS_BASIS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Sales Tax Basis Amount
44	EXS_BASIS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Sales Tax Basis Amount Base Currency
45	EXS_BASIS_AMT_RPT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Sales Tax Basis Amount Reporting Currency
46	HSN_CODE	Character(10)	VARCHAR2(10) NOT NULL	HSN Code for GST
47	SAC_CODE	Character(10)	VARCHAR2(10) NOT NULL	SAC Code
48	REV_CHARGE_APPL	Character(1)	VARCHAR2(1) NOT NULL	Reverse Charge Applicability
49	GST_RGSTN_NBR	Character(30)	VARCHAR2(30) NOT NULL	GST Registration Number
50	GST_RGSTN_NBR_ORG	Character(30)	VARCHAR2(30) NOT NULL	GST Registration Number
51	EXS_TXRTAMT_TRC	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Rate Currency
52	EXS_CURRENCY_TRC	Character(3)	VARCHAR2(3) NOT NULL	Curreny Tax Rate
53	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
54	GROSS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Gross Amount
55	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
56	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
57	EXS_RCVRY_PCT	Number(8,4)	DECIMAL(7,4) NOT NULL	Tax Percentage
58	EXS_RCVRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Recovery Amount
59	EXS_RCVRY_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Recovery Amount
60	EXS_RCVRY_AMT_RPT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Reporting Recovery Amount
61	EXS_NRCVRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Non Recovery Amount
62	EXS_NRCVRY_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Non Base Recovery Amount
63	EXS_NRCVRY_AMT_RPT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Non Recovery Reporting Amount
64	ITM_SETID	Character(5)	VARCHAR2(5) NOT NULL	Item SetID
65	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
66	EXD_TAX_ITEM_TYPE1	Character(4)	VARCHAR2(4) NOT NULL	Tax Item Type
67	ITEM	Character(30)	VARCHAR2(30) NOT NULL	Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
68	EXS_TAX_RATE_UOM	Character(3)	VARCHAR2(3) NOT NULL	Excise Unit Of Measure
69	EXS_TAX_RATE_SEQ	Number(3,0)	SMALLINT NOT NULL	Tax Rate Sequence
70	STX_TAX_CATG_CD	Character(10)	VARCHAR2(10) NOT NULL	Sales Tax Category. This field is used to capture vendor, customer, item and product categories
71	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
72	ENTRY_DT	Date(10)	DATE	Specifies the date that a group of pending items was entered into the system. This date may be later or the same as the date that the items were received by the organization (See RECEIVED_DT).
73	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
74	DEPOSIT_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.
75	VERSION_CHAR	Character(10)	VARCHAR2(10) NOT NULL	Version
76	IRN	Character(64)	VARCHAR2(64) NOT NULL	Invoice Reference Number
77	IRP_DATE	DateTime(26)	TIMESTAMP	IRP Date
78	QR_CODE	Long Character	CLOB	QR Code
79	TPR_TYPE1	Character(30)	VARCHAR2(30) NOT NULL	Trading Partner type
80	GST_EXPORT_TYPE1	Character(4)	VARCHAR2(4) NOT NULL	GST Export Type
81	INVOICE_TYP_SU_CD1	Character(3)	VARCHAR2(3) NOT NULL	Invoice Type Sub Code
82	GST_DOC_TYPE1	Character(4)	VARCHAR2(4) NOT NULL	GST Document Type
83	GST_IMPORT_TYPE1	Character(4)	VARCHAR2(4) NOT NULL	GST Import Type
84	GST_ITM_TAX_APPL1	Character(4)	VARCHAR2(4) NOT NULL	GST Item Tax Applicability
85	GST_ITC_ELIG1	Character(4)	VARCHAR2(4) NOT NULL	GST Input Tax Credit Eligibile
86	ITC_SUPINV_IRN	Character(64)	VARCHAR2(64) NOT NULL	IRN
87	GST_IRN_APPL	Character(1)	VARCHAR2(1) NOT NULL	GST IRN Applicability
88	GROUP_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Specifies the system-assigned sequence number of a pending item within a group. A group is a postable entity that may be entered online or created by the system. In either case the group sequence number is automatically generated.
89	GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.
90	GST_TXN_CATG1	Character(30)	VARCHAR2(30) NOT NULL	GST Transaction Category