| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
RUN_DT |
Date(10) |
DATE |
Run Date
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 5 |
ASSN_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the operator ID of the person who will enter items in a group. This is used when one person enters the control totals and another person enters the actual transactions. The assigned operator is also the person who processes the group and the person who is shown on group inquiry and processing panels.
|
| 6 |
POST_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a control group of pending items has been fully posted to customer accounts. The posting status also indicates whether or not there were errors encountered during posting. This field is automatically populated by the Receivables Update program.
%=All
C=Complete
E=Errors
N=Not Posted
|
| 7 |
POST_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a group of pending items is ready to be processed by the Receivable Update program. The "action" requested can be no action, priority scheduled or standard scheduled.
A=Do Not Post
B=Balance Only Now
D=Delete This Group Now
E=Delete ALL Accounting Entries
G=Generate GL Distribution
I=Balance and Post Later
L=Batch Standard
N=Batch Priority
V=View
|
| 8 |
ORIGIN_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the source or method of entry for a pending item group.
|
| 9 |
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
|
| 10 |
CONTROL_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the currency for all Receivables items in a control group. If this field is not blank the system will accept items with the specified currency only.
|
| 11 |
DUMMY_FIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dummy Field for Hiding Groups
|
| 12 |
PUBLIC_SECTOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Public Sector
|
| 13 |
MULTIBOOK_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Multibook entries in Subsystem
Y/N Table Edit
Default Value: N
|
| 14 |
TUNING_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Tuning Mode
D=On - Display Bind Setups
N=Delete Work Files
S=On - Stop at specified stmt
W=Retain Work Files
Y=On
|
| 15 |
REQUEST_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Request Number
|
| 16 |
PGG_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
PGG Mode of Operation
|
| 17 |
PGG_GROUP_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Group Unit
|
| 18 |
PGG_GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Group ID
|
| 19 |
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.
|
| 20 |
DEPOSIT_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Identifies the business unit to which a deposit is posted.
|
| 21 |
PGG_GROUP_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
PGG Group Type
B=Billing
D=Draft
F=Finance Charge
M=Maintenance
P=Payment
T=Transfer
U=Unpost
|
| 22 |
GROUP_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Specifies a category of transactions included in a group of receivables pending items. The group type affects processing of the transactions and is useful for as a sort/selection option for reports and inquiries. Examples of group type are Billing (for invoices) Payments and Transfers.
|
| 23 |
GROUP_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Represents the high level grouping of multiple general ledger business units.
|
| 24 |
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.
|
| 25 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 26 |
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.
|
| 27 |
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.
|
| 28 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 29 |
ITEM_LINE |
Number(6,0) |
INTEGER NOT NULL |
Item Line
|
| 30 |
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.
|
| 31 |
DST_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Distribution Sequence
|
| 32 |
TAX_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Tax Code
|
| 33 |
VAT_APPLICABILITY |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt
N=Not Applicable
O=Outside of Scope of VAT
S=Suspended
T=Taxable
V=VAT Only
X=Exonerated
|
| 34 |
VAT_TXN_TYPE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
|
| 35 |
TAX_CD_VAT |
Character(8) |
VARCHAR2(8) NOT NULL |
Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
|
| 36 |
VAT_DST_ACCT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Specifies the accounting code associated with a VAT account type and with a VAT transaction. The accounting code determines when and how the transaction is distributed (posted) to the general ledger.
|
| 37 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 38 |
GROUP_ID_SEQ_NUM |
Number(15,0) |
DECIMAL(15) NOT NULL |
Group ID
|
| 39 |
DRAFT_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Identifies the Receivables business unit associated with a draft. This field is maintained by the Draft Creation process.
|
| 40 |
DRAFT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies a payment draft. The Draft ID is system-generated during the Draft Creation process or manually entered.
|
| 41 |
WORK_CNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Count of Anything
|
| 42 |
TAX_RATE_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Tax Rate Sequence
|
| 43 |
PAYMENT_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.
|
| 44 |
AE_N3 |
Number(3,0) |
SMALLINT NOT NULL |
3
|
| 45 |
AE_N6 |
Number(6,0) |
INTEGER NOT NULL |
6
|
| 46 |
AE_INT_2 |
Number(2,0) |
SMALLINT NOT NULL |
Number Work Field
|
| 47 |
AE_INT_6 |
Number(6,0) |
INTEGER NOT NULL |
Number Work Field
|
| 48 |
AE_INT_15 |
Number(15,0) |
DECIMAL(15) NOT NULL |
Number Work Field
|
| 49 |
AE_ROUND_INC |
Signed Number(8,5) |
DECIMAL(6,5) NOT NULL |
Rounding Increment
|
| 50 |
DECIMALPOS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|
| 51 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 52 |
AMOUNT_1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Work Field
|
| 53 |
AMOUNT_2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Work Field
|
| 54 |
FOREIGN_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
|
| 55 |
MONETARY_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
|
| 56 |
VAT_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges.
|
| 57 |
VAT_BASIS_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. It is specified in the base currency of the General Ledger business unit associated with the transaction. Refer to the definition of VAT_BASIS_AMT.
|
| 58 |
VAT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.
|
| 59 |
VAT_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. It is expressed in the base currency of the General Ledger business unit associated with the transaction. Refer to the definition for VAT_AMT.
|
| 60 |
AR_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
A number that is assigned to draft items to ensure uniqueness of key
|
| 61 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 62 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 63 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 64 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 65 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 66 |
PRIMARY_LEDGER |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) a ledger is designated as the primary ledger in a ledger group.
|
| 67 |
ENTRY_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the monetary amount of a pending item transaction such as invoice or credit memo in the base currency of the business unit.
|
| 68 |
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.
|
| 69 |
ENTRY_REASON |
Character(5) |
VARCHAR2(5) NOT NULL |
"Specifies an entry reason that further qualifies the entry type associated with a pending item. For example an entry reason for a credit memo might be ""Pricing Error"" or ""Shipping Error""."
|
| 70 |
DST_ID_AR |
Character(10) |
VARCHAR2(10) NOT NULL |
Specifies the general ledger ChartField combination that is affected when subsequent activity such as a payment occurs for the item.
|
| 71 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 72 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
Default Value: 1
|
| 73 |
PGG_EXISTS |
Number(1,0) |
SMALLINT NOT NULL |
Exists Indicator
|
| 74 |
AE_CHUNK_BY |
Character(20) |
VARCHAR2(20) NOT NULL |
Chunking Method
|
| 75 |
AE_CHUNK_BY_VALUE |
Character(15) |
VARCHAR2(15) NOT NULL |
Current value of chunk-by fld
|
| 76 |
TABLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Table Name
|
| 77 |
TAO_AUTO_ENTRY |
Character(20) |
VARCHAR2(20) NOT NULL |
Auto Entry TAO table name
|
| 78 |
TAO_DST_AR |
Character(20) |
VARCHAR2(20) NOT NULL |
AR Dist TAO table name
|
| 79 |
TAO_DST_BAL |
Character(20) |
VARCHAR2(20) NOT NULL |
Dist Balancing TAO table name
|
| 80 |
TAO_DST_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Dist Code TAO table name
|
| 81 |
TAO_DST_DM |
Character(20) |
VARCHAR2(20) NOT NULL |
Distribution codes for drafts
|
| 82 |
TAO_GROUP |
Character(20) |
VARCHAR2(20) NOT NULL |
Pending Group TAO table name
|
| 83 |
TAO_ITEM |
Character(20) |
VARCHAR2(20) NOT NULL |
Sys Item TAO table name
|
| 84 |
TAO_ITEM_ACTE |
Character(20) |
VARCHAR2(20) NOT NULL |
Item_act_ent_vw TAO table name
|
| 85 |
TAO_ITEM_ACTV |
Character(20) |
VARCHAR2(20) NOT NULL |
Item_act_vat_vw TAO table name
|
| 86 |
TAO_ITEM_VATI |
Character(20) |
VARCHAR2(20) NOT NULL |
Item_vat_int_vw TAO table name
|
| 87 |
TAO_ITEM_DST |
Character(20) |
VARCHAR2(20) NOT NULL |
Item Dst TAO table name
|
| 88 |
TAO_ITEM_ENTRY |
Character(20) |
VARCHAR2(20) NOT NULL |
Item Entry TAO table name
|
| 89 |
TAO_PENDDST |
Character(20) |
VARCHAR2(20) NOT NULL |
Pending Dst TAO table name
|
| 90 |
TMP_PENDDST |
Character(20) |
VARCHAR2(20) NOT NULL |
Pending Dst TMP table name
|
| 91 |
TAO_PENDVAT |
Character(20) |
VARCHAR2(20) NOT NULL |
Pending VAT TAO table name
|
| 92 |
TAO_REQUEST |
Character(20) |
VARCHAR2(20) NOT NULL |
PGG Request TAO table name
|
| 93 |
TAO_VAT_SEQ |
Character(20) |
VARCHAR2(20) NOT NULL |
VAT Seq Nbr TAO table name
|
| 94 |
TAO_VATAMT |
Character(20) |
VARCHAR2(20) NOT NULL |
VAT Amounts TEMP TABLE
|
| 95 |
TAO_RQST2 |
Character(20) |
VARCHAR2(20) NOT NULL |
Request table -2
|
| 96 |
TAO_ITRATE |
Character(20) |
VARCHAR2(20) NOT NULL |
Item Rate table
|
| 97 |
TAO_LEDCUR |
Character(20) |
VARCHAR2(20) NOT NULL |
Ledger Currency table
|
| 98 |
TAO_LEDOLD |
Character(20) |
VARCHAR2(20) NOT NULL |
Old Ledger Currency table
|
| 99 |
TAO_MULTDST |
Character(20) |
VARCHAR2(20) NOT NULL |
Multibook distribution table
|
| 100 |
TAO_CURRT |
Character(20) |
VARCHAR2(20) NOT NULL |
Currency Rate Table
|
| 101 |
TAO_CURRT2 |
Character(20) |
VARCHAR2(20) NOT NULL |
Currency Rate Table -2
|
| 102 |
TAO_CUROLD |
Character(20) |
VARCHAR2(20) NOT NULL |
Currency Rate Table Old
|
| 103 |
TAO_SUFFIX |
Character(1) |
VARCHAR2(1) NOT NULL |
TAO table suffix (optional)
|
| 104 |
TAO_PDST2 |
Character(20) |
VARCHAR2(20) NOT NULL |
Pending Dst 2 TAO
|
| 105 |
TAO_MDST2 |
Character(20) |
VARCHAR2(20) NOT NULL |
Mult Dst 2 TAO
|
| 106 |
TAO_PDST3 |
Character(20) |
VARCHAR2(20) NOT NULL |
Pend Dst 3 TAO
|
| 107 |
TAO_RTDFLT |
Character(20) |
VARCHAR2(20) NOT NULL |
Rt Dflt Vw Temp
|
| 108 |
TAO_DFTREC |
Character(20) |
VARCHAR2(20) NOT NULL |
Draft Receivable Distribution
|
| 109 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 110 |
FIELDNAME1 |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name 1
|
| 111 |
FIELDNUM |
Number(4,0) |
SMALLINT NOT NULL |
Field Number
|
| 112 |
AE_COND_OPER |
Character(2) |
VARCHAR2(2) NOT NULL |
Condition Operator
|
| 113 |
ISTRUE |
Character(100) |
VARCHAR2(100) NOT NULL |
ISTRUE SQL function (AE)
|
| 114 |
KEEPGOING |
Character(125) |
VARCHAR2(125) NOT NULL |
KEEPGOING SQL function (AE)
|
| 115 |
AE_WHERE |
Character(254) |
VARCHAR2(254) NOT NULL |
AE Generic Where Clause
|
| 116 |
AE_WHERE_1 |
Character(50) |
VARCHAR2(50) NOT NULL |
AE_WHERE_1
|
| 117 |
AE_WHERE_2 |
Character(50) |
VARCHAR2(50) NOT NULL |
AE_WHERE_2
|
| 118 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 119 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 120 |
PRODUCT_FAMILY |
Character(1) |
VARCHAR2(1) NOT NULL |
Product Family
|
| 121 |
VAT_DFLT_WRK |
Character(2) |
VARCHAR2(2) NOT NULL |
VAT Defaulting Work
Default Value: 2
|
| 122 |
DOC_TYPE_IU |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
|
| 123 |
AR_PREFIX |
Character(2) |
VARCHAR2(2) NOT NULL |
Record prefix (alias) used for AR inheritance.
|
| 124 |
AR_INHERITANCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag used in PGG_SERV to indicate if any ChartFields are set to always inherit or inherit within unit on the ARBI inheritance group.
|
| 125 |
AR_BANK_INHERIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Receivables Bank Inheritance
|
| 126 |
DRAFT_BUSN_EVENT |
Character(2) |
VARCHAR2(2) NOT NULL |
Defines the Draft life cycle event. It represents one of the actions that the PeopleSoft system has provided for Draft processing. Examples are: Approving a Draft Remitting a Draft to the Bank Voiding the Draft.
|
| 127 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 128 |
ENTRY_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the currency associated with the monetary amount of a pending item.
|
| 129 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 130 |
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.
|
| 131 |
DD_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Specifies a sequence number assigned to a Direct Debit by the Direct Debit generation process.
|
| 132 |
RP_PARM_GRPTYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Type
|
| 133 |
AE_WHERE_3 |
Character(50) |
VARCHAR2(50) NOT NULL |
AE_WHERE_3
|
| 134 |
AE_WHERE_4 |
Character(50) |
VARCHAR2(50) NOT NULL |
AE_WHERE_4
|
| 135 |
AE_WHERE_6 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where 6
|
| 136 |
AE_WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Dynamic where clause
|
| 137 |
BUDGET_DT |
Date(10) |
DATE |
Budget Date
|
| 138 |
BUDGET_DT_OVER_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Date Override
|
| 139 |
SYNC_BUDGET_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicate whether to use the same budget date for both recognized and collected bucket
N=No
Y=Yes
|
| 140 |
COMMITMENT_CNTL |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Commitment Control
|
| 141 |
SEQ_NUM4 |
Number(6,0) |
INTEGER NOT NULL |
Sequence
|
| 142 |
DST_SEQ_NUM_MAX |
Number(6,0) |
INTEGER NOT NULL |
Distribution Sequence
|
| 143 |
FOREIGN_AMOUNT2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Foreign Amount 2
|
| 144 |
MONETARY_AMOUNT_02 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
|
| 145 |
BUSINESS_UNIT_2 |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 146 |
CUST_ID2 |
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.
|
| 147 |
EXS_TAX_RATE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Rate Code
|
| 148 |
EXS_TAX_RATE_PCT |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Tax Rate Percentage
|
| 149 |
EXS_TAX_RATE_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Tax Rate Sequence
|
| 150 |
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
|
| 151 |
EXS_TAX_CMPNT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Component Code
|
| 152 |
EXS_TAX_DEP_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Dependency Code
|
| 153 |
EXS_CALC_SCHEME |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculation Scheme
A=Amount
P=Percentage
Q=Quantity
|
| 154 |
EXS_TAXRT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Rate Amount
|
| 155 |
EXS_TAXRT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Rate Amount
|
| 156 |
EXS_TAXRT_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Rate Amount
|
| 157 |
EXD_DST_ACCT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Excise Distribution Account Type. This field is used to assign chart fields for a particular tax location and will have various translate values.
CNCA=Cenvat Clearing Account
CNCG=Cenvat on Capital Goods
CNCI=Cenvat Clearing Imports ACD
CNHA=Cenvat utilization on Hold Acc
CNHC=Cenvat Hold on Capital Goods
CNHS=Cenvat Hold for Sub Contractin
CNRM=Cenvat on Raw Materials
CNSU=Cenvat Suspense Account
CSDN=Custom Duty Non-Recoverable
EXDC=Excise Dty recovd from Customr
EXDE=Excise Duty Expenses
KKC=Krishi Kalyan Cess on Purchase
KKCP=Krishi Kalyan Cess on Sales
PLAA=PLA Account
SBC=Swachh Bharat Cess on Purchase
SBCP=Swachh Bharat Cess on Sales
SERV=Service Tax
SST=Suspense Service Tax
|
| 158 |
EXS_RCVRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Recovery Amount
|
| 159 |
EXS_RCVRY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Recovery Amount
|
| 160 |
EXD_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Tax Amount
|
| 161 |
EXS_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Basis Amount
|
| 162 |
EXD_TAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Duty in Base Currency
|
| 163 |
STX_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 164 |
STX_TAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
SALES TAX IN BASE CURR
|
| 165 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 166 |
WHERE_CF_ARBI |
Long Character(4000) |
CLOB |
Field List
|
| 167 |
BAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Item Balance
|
| 168 |
IU_TRANS |
Character(1) |
VARCHAR2(1) NOT NULL |
Inter Unit Transaction
|
| 169 |
FIELD_LIST_CF1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Chartfield list
|
| 170 |
FIELD_LIST_CF2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Chartfield list
|
| 171 |
DST_SEQ_NUM_MAX1 |
Number(6,0) |
INTEGER NOT NULL |
Distribution Sequence
|
| 172 |
GWA_REPORTER_AR |
Character(1) |
VARCHAR2(1) NOT NULL |
GWA Reporter Validation field
|
| 173 |
USF_TAS |
Character(26) |
VARCHAR2(26) NOT NULL |
USF TAS (Treasury Account Symbol)
|
| 174 |
USF_BETC |
Character(8) |
VARCHAR2(8) NOT NULL |
USF Business Event Type Code
|
| 175 |
USF_BETC_TO |
Character(8) |
VARCHAR2(8) NOT NULL |
USF Business Event Type Code
|
| 176 |
AR_FIELDNAME_FC |
Character(18) |
VARCHAR2(18) NOT NULL |
Fieldname for Fund Code.
|
| 177 |
AR_FIELDVALUE_FC |
Character(5) |
VARCHAR2(5) NOT NULL |
Field Value used to store value of cf
|
| 178 |
EXS_TAX_RATE_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Excise Unit Of Measure
|
| 179 |
EXS_CURRENCY_RPTG |
Character(3) |
VARCHAR2(3) NOT NULL |
Excise Currency Reporting
|
| 180 |
EXS_CURRENCY_TRC |
Character(3) |
VARCHAR2(3) NOT NULL |
Curreny Tax Rate
|
| 181 |
EXS_NRCVRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Non Recovery Amount
|
| 182 |
EXS_NRCVRY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Non Base Recovery Amount
|
| 183 |
EXS_RCVRY_PCT |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Tax Percentage
|
| 184 |
STX_TAX_AUTH_RPT |
Character(8) |
VARCHAR2(8) NOT NULL |
Reporting Authority (India Sales Tax)
|
| 185 |
STATE_SHIP_FROM |
Character(6) |
VARCHAR2(6) NOT NULL |
Ship From State
|
| 186 |
STATE_SHIP_TO |
Character(6) |
VARCHAR2(6) NOT NULL |
Ship To State
|
| 187 |
EXS_NRCVRY_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Non Recovery Reporting Amount
|
| 188 |
TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Amount
|
| 189 |
TAX_AMT_S |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Amount
|
| 190 |
TOTAL_CGST_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total CGST Tax Amount
|
| 191 |
TOTAL_SGST_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total SGST Tax Amount
|
| 192 |
TOTAL_IGST_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total IGST Tax Amount
|
| 193 |
CGST_AMT_REM |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
CGST Amount Remaining
|
| 194 |
SGST_AMT_REM |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
SGST Adjusted Tax Amount
|
| 195 |
IGST_AMT_REM |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
IGST Adjusted Tax Amount
|
| 196 |
CGST_AMT_ADJ |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
CGST Adjusted Tax Amount
|
| 197 |
SGST_AMT_ADJ |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
SGST Adjusted Tax Amount
|
| 198 |
IGST_AMT_ADJ |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
IGST Adjusted Tax Amount
|
| 199 |
FIELD2 |
Character(50) |
VARCHAR2(50) NOT NULL |
Fieldname 2
|