GST_TXN_TBL

(SQL Table)
Index Back

GST Transaction Table

GST Transaction Table for GST Transaction loader

# 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_TYPE Character(4) VARCHAR2(4) NOT NULL Tax Transaction Type. This field will be used in the Tax determination and calculation of taxes.
DEB=Direct Export With Bond
DEWB=Direct Export Without Bond
DIMP=Direct Import
DOM=Domestic
LEB=Local Export With Bond
LEWB=Local Export Without Bond
LIMP=Local Import
11 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
12 EXS_TAX_TYPE Character(1) VARCHAR2(1) NOT NULL Tax Type
C=Custom Duty
E=Excise Duty
G=Goods and Services Tax
S=Sales Tax / VAT
13 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services
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_TYPE Character(3) VARCHAR2(3) NOT NULL Invoice Type
ACR=Credit Bill
ADJ=Adjustment Only bill
ARB=Rebill Bill
PRF=Pro Forma Invoice
RAD=Regular bill with adjustments
REG=Regular Bill
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_TYPE Character(1) VARCHAR2(1) NOT NULL Voucher Type
A=Adjustment Voucher
B=Batch Edit Voucher
C=Recurring Voucher
E=ERS Voucher
J=Journal Voucher
N=Reversal Voucher
P=Prepaid Voucher
R=Regular Voucher
T=Third Party Voucher
V=Registered Voucher
X=Template Voucher
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_TYPE Character(4) VARCHAR2(4) NOT NULL Tax Item Type
C=Capital Goods
F=Finished Goods
R=Raw Material
S=Service
67 RPT_PROCESS Character(1) VARCHAR2(1) NOT NULL In process flag

Default Value: N

68 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.
69 EXS_TAX_RATE_UOM Character(3) VARCHAR2(3) NOT NULL Excise Unit Of Measure
70 EXS_TAX_RATE_SEQ Number(3,0) SMALLINT NOT NULL Tax Rate Sequence
71 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
72 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
73 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).
74 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
75 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.
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_TYPE Character(30) VARCHAR2(30) NOT NULL Trading Partner type
80 GST_EXPORT_TYPE Character(4) VARCHAR2(4) NOT NULL GST Export Type
81 INVOICE_TYP_SUB_CD Character(3) VARCHAR2(3) NOT NULL Invoice Type Sub Code
82 GST_DOC_TYPE Character(3) VARCHAR2(3) NOT NULL GST Document Type
CRN=Credit Note
DBN=Debit Note
INV=Regular Invoice
83 VERSION_CHAR Character(10) VARCHAR2(10) NOT NULL Version
84 EINV_PROC_FLAG Character(1) VARCHAR2(1) NOT NULL E-Invoice Processing Flag
C=Credit after Cut-Off Time
E=Excluded from E-Invoicing
I=In Process
L=Login Credentials Issue
M=Manual Upload
N=Not Processed
R=Retry
X=Rejected
Y=Completed
Z=Other Error or Multiple Errors
85 GST_IMPORT_TYPE Character(4) VARCHAR2(4) NOT NULL GST Import Type
86 GST_ITM_TAX_APPL Character(4) VARCHAR2(4) NOT NULL GST Item Tax Applicability
CTP=Composite Taxable Person
EXMT=Exempt
NGST=Non GST
NR=Nil Rate
87 GST_ITC_ELIG Character(4) VARCHAR2(4) NOT NULL GST Input Tax Credit Eligibile
CGDS=Capital Goods
IE=Ineligible
INPT=Inputs
INSR=Input Services
88 ITC_SUPINV_IRN Character(64) VARCHAR2(64) NOT NULL IRN
89 GST_IRN_APPL Character(1) VARCHAR2(1) NOT NULL GST IRN Applicability
90 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.
91 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.
92 GST_TXN_CATG Character(30) VARCHAR2(30) NOT NULL GST Transaction Category