GST_TXN_TBL(SQL Table) |
Index Back |
---|---|
GST Transaction TableGST 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 |