ITEM_GST

(SQL Table)
Index Back

Item GST Details

Item GST details

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GROUP_BU Character(5) VARCHAR2(5) NOT NULL Represents the high level grouping of multiple general ledger business units.
2 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.
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 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.
5 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.
6 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line
7 VERSION_CHAR Character(10) VARCHAR2(10) NOT NULL Version
8 IRN Character(64) VARCHAR2(64) NOT NULL Invoice Reference Number
9 IRP_DATE DateTime(26) TIMESTAMP IRP Date
10 TPR_TYPE Character(30) VARCHAR2(30) NOT NULL Trading Partner type
11 GST_TXN_CATG Character(30) VARCHAR2(30) NOT NULL GST Transaction Category
12 GST_DOC_TYPE Character(3) VARCHAR2(3) NOT NULL GST Document Type
CRN=Credit Note
DBN=Debit Note
INV=Regular Invoice
13 REV_CHARGE_APPL Character(1) VARCHAR2(1) NOT NULL Reverse Charge Applicability
14 RPT_PROCESS Character(1) VARCHAR2(1) NOT NULL In process flag

Default Value: N