PENDING_TAX(SQL Table) |
Index Back |
|---|
| # | 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 | 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. |
| 8 | TAX_RATE_SEQ |
Number(3,0) | SMALLINT NOT NULL | Tax Rate Sequence |
| 9 | EXD_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Excise Applicablity Flag. This field is used to indicate the applicability of Excise duty with respect to a vendor, customer, item or product. It will have Yes or No values. |
| 10 | STX_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Sales Tax Applicability. |
| 11 | 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 |
| 12 | STX_TAX_AUTH_RPT | Character(8) | VARCHAR2(8) NOT NULL | Reporting Authority (India Sales Tax) |
| 13 | STATE_SHIP_TO | Character(6) | VARCHAR2(6) NOT NULL | Ship To State |
| 14 | STATE_SHIP_FROM | Character(6) | VARCHAR2(6) NOT NULL | Ship From State |
| 15 | EXS_TXN_LINE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Line Amount |
| 16 | EXD_TAX_CATG_CD | Character(10) | VARCHAR2(10) NOT NULL | Excise Tax Category. This field is used to capture vendor, customer, item and product categories |
| 17 | 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 |
| 18 | EXD_TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Tax Amount |
| 19 | EXD_TAX_RATE_CD | Character(10) | VARCHAR2(10) NOT NULL | Excise Tax Calculation Code |
| 20 | EXD_TAX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Duty in Base Currency |
| 21 | EXD_TAX_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Duty Amt In Rpt Curr |
| 22 | STX_TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sales Tax Amount |
| 23 | STX_TAX_RATE_CD | Character(10) | VARCHAR2(10) NOT NULL | Sales Tax Calculation Code |
| 24 | STX_TAX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | SALES TAX IN BASE CURR |
| 25 | STX_TAX_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | SALES TAX IN REPORT CURR |
| 26 | EXS_CURRENCY_RPTG | Character(3) | VARCHAR2(3) NOT NULL | Excise Currency Reporting |
| 27 | STX_FORM_CD | Character(8) | VARCHAR2(8) NOT NULL |
Form Code
Prompt Table: STX_FORM_CD_VW |
| 28 | BU_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL | BU Aplicability Flag |
| 29 | EXS_DTL_LINK | Character(1) | VARCHAR2(1) NOT NULL | Tax Detail Link |
| 30 | SUM_TOT_EXD_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Excise Duty |
| 31 | SUM_TOT_EXD_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Excise Duty |
| 32 | SUM_TOT_STX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Sales Tax/VAT |
| 33 | SUM_TOT_STX_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Sales Tax/VAT |
| 34 | SUM_TOT_TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sum of Total Amount |
| 35 | RATE_DIV_RPT | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Div Report |
| 36 | RATE_MULT_RPT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Mult Report |
| 37 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 38 | EXD_TAX_RATE_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Excise Tax Rate Source
1=System Defined 2=Manually Entered |
| 39 | STX_TAX_RATE_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Tax Rate Source
1=System Defined 2=Manually Entered |
| 40 | ORG_SETID | Character(5) | VARCHAR2(5) NOT NULL | Organization SetID. |
| 41 | ORG_CODE | Character(6) | VARCHAR2(6) NOT NULL | Organization Code. This will be unique to an Organization. |
| 42 | ORG_TAX_LOC_CD | Character(10) | VARCHAR2(10) NOT NULL | Tax Location Code. An Organization can have multiple Tax Location Codes. |
| 43 | EXS_TXC_LN_STATUS | Character(2) | VARCHAR2(2) NOT NULL | |
| 44 | EXD_UOM | Character(3) | VARCHAR2(3) NOT NULL | Excise Unit Of Measure |
| 45 | RATE_MULT_EXS | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Excise Rt Multiplier |
| 46 | RATE_DIV_EXS | Number(16,8) | DECIMAL(15,8) NOT NULL | Excise Rt Divider |
| 47 | COUNTRY_SHIP_FROM | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country from which the invoice contents were shipped (for VAT processing only). |
| 48 | COUNTRY_SHIP_TO | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country to which the invoice contents were shipped (for VAT processing only). |
| 49 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 50 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 51 | ENTRY_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Specifies the currency associated with the monetary amount of a pending item. |
| 52 | VERSION_CHAR | Character(10) | VARCHAR2(10) NOT NULL | Version |
| 53 | IRN | Character(64) | VARCHAR2(64) NOT NULL | Invoice Reference Number |
| 54 | IRP_DATE | DateTime(26) | TIMESTAMP | IRP Date |
| 55 | QR_CODE | Long Character | CLOB | QR Code |
| 56 | TPR_TYPE | Character(30) | VARCHAR2(30) NOT NULL | Trading Partner type |
| 57 | GST_TXN_CATG | Character(30) | VARCHAR2(30) NOT NULL | GST Transaction Category |
| 58 | GST_DOC_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
GST Document Type
CRN=Credit Note DBN=Debit Note INV=Regular Invoice |
| 59 | REV_CHARGE_APPL | Character(1) | VARCHAR2(1) NOT NULL | Reverse Charge Applicability |
| 60 | RPT_PROCESS | Character(1) | VARCHAR2(1) NOT NULL |
In process flag
Default Value: N |