| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
ENTRY_USE_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the System Function or type of processing associated with an entry type.
|
| 3 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 4 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 5 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 6 |
PP_METHOD |
Character(15) |
VARCHAR2(15) NOT NULL |
Payment Predictor Method
|
| 7 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 8 |
PP_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 9 |
PP_USAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Usage
1=First...
2=Any Overpayment
3=Overpayment Exceeds
4=Overpayment Is Less Than
5=Any Underpayment
6=Underpayment Exceeds
7=Underpayment Is Less Than
|
| 10 |
PP_SORT_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sorting Sequence number
|
| 11 |
PP_MICR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Customers Identified
I=Doesn't Matter
M=More Than One
N=None
S=One
Default Value: N
|
| 12 |
PP_REF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
References Supplied
D=Detail
I=Doesn't Matter
N=No
Y=Summary
Default Value: N
|
| 13 |
PP_MAIN_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
Main use
A=Execute Algorithm Group
C=Apply To Control Customer
I=Generate An Item
M=Execute Custom Algorithm
N=Release The Payment
W=Generate A Worksheet
Default Value: N
|
| 14 |
ALGORITHM |
Character(7) |
VARCHAR2(7) NOT NULL |
Algorithm Identifier
|
| 15 |
ALGORITHM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Algorithm Group for Payment Predictor
|
| 16 |
PP_MAIN_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Main Control Account BU
Prompt Table:
BUS_UNIT_TBL_GL
|
| 17 |
PP_MAIN_CUSTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Main Control Account Custid
Prompt Table:
CUSTOMER
|
| 18 |
PP_MAIN_SYSFUNC |
Character(5) |
VARCHAR2(5) NOT NULL |
Main system function Id
Prompt Table:
ENTRY_USE_TBL
|
| 19 |
PP_MAIN_TOL |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Tolerance Amount
|
| 20 |
PP_REVIEW_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Require Review
|
| 21 |
PP_TAG_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Select Items
|
| 22 |
PP_MODULE |
Character(15) |
VARCHAR2(15) NOT NULL |
External Module Name
|
| 23 |
PP_MAIN_TOL_PER |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Tolerance Percent
|
| 24 |
PP_MET_CNT |
Number(3,0) |
SMALLINT NOT NULL |
Methods
|
| 25 |
PP_STEP_CNT |
Number(3,0) |
SMALLINT NOT NULL |
Steps
|
| 26 |
PP_REQ_CNT |
Number(3,0) |
SMALLINT NOT NULL |
Requests
|
| 27 |
AE_EXISTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exists
|
| 28 |
DEPOSIT_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Identifies the business unit to which a deposit is posted.
|
| 29 |
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.
|
| 30 |
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.
|
| 31 |
AUTO_NUMBER_PREFIX |
Character(3) |
VARCHAR2(3) NOT NULL |
Auto Numbering Prefix
|
| 32 |
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.
|
| 33 |
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""."
|
| 34 |
PP_DISPOSITION |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Disposition
N=Do Nothing
P=Post
W=Generate Worksheet
|
| 35 |
PP_L_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Setid
|
| 36 |
PP_L_METHOD |
Character(15) |
VARCHAR2(15) NOT NULL |
Last Method
|
| 37 |
PP_L_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Last Seq
|
| 38 |
PP_L_MICR |
Character(1) |
VARCHAR2(1) NOT NULL |
Last Micr
|
| 39 |
PP_L_REF |
Character(1) |
VARCHAR2(1) NOT NULL |
Last Ref Status
|
| 40 |
PP_ORIG_MICR_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Orig Micr Stat
|
| 41 |
PP_ORIG_REF_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Orig Ref Stat
|
| 42 |
PP_C_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Current seq
|
| 43 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 44 |
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.
|
| 45 |
CUST_ID1 |
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.
|
| 46 |
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.
|
| 47 |
ITEM_LINE |
Number(6,0) |
INTEGER NOT NULL |
Item Line
|
| 48 |
PP_L_DEP_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Deposit Bu
|
| 49 |
PP_L_DEP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Deposit ID
|
| 50 |
PP_L_PAY_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Payment Seq
|
| 51 |
GROUP_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Represents the high level grouping of multiple general ledger business units.
|
| 52 |
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.
|
| 53 |
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.
|
| 54 |
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.
|
| 55 |
REF_QUALIFIER_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
Reference Qualifier Code
|
| 56 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 57 |
FIELDTYPE |
Number(2,0) |
SMALLINT NOT NULL |
Field Type (from PSST0101 Ref.)
|
| 58 |
PP_APPL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Application Status
C=Completely Applied
N=Not Applied
O=Over Applied
U=Under Applied
|
| 59 |
PP_ITEM |
Character(30) |
VARCHAR2(30) NOT NULL |
Item
|
| 60 |
BAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Item Balance
|
| 61 |
BAL_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code - Bal Amount
|
| 62 |
PP_PARTIAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Partial Amt
|
| 63 |
PARTIAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Partial sell/buyback amount
|
| 64 |
PARTIAL_AMT_2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Partial sell/buyback amount
|
| 65 |
PP_ITEM_TOTAL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Item Total
|
| 66 |
AMT_SEL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount selected
|
| 67 |
PP_PAYMENT_USED |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Used
|
| 68 |
DISC_EARNED |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discounts Earned
|
| 69 |
DISC_PAY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Amt Pay
|
| 70 |
PP_CREDIT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit indicator
|
| 71 |
DUE_DT |
Date(10) |
DATE |
Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
|
| 72 |
PAYMENT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of a customer payment.
|
| 73 |
PP_RQ |
Number(7,0) |
INTEGER NOT NULL |
Reference Qualifier Count
|
| 74 |
PP_RQ_HIT |
Number(7,0) |
INTEGER NOT NULL |
Reference Qualifier Hits
|
| 75 |
AMT_ADJ |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Adjusted
|
| 76 |
AMT_REM |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Remaining
|
| 77 |
SUM_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Summary amount used in reconciliation
|
| 78 |
WS_COUNT |
Number(5,0) |
INTEGER NOT NULL |
Worksheet Items
|
| 79 |
ID_PAY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Reference payment amount
|
| 80 |
PAY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Payment Amount
|
| 81 |
DISC_TAKEN |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Taken
|
| 82 |
DISC_UNEARNED |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Unearned Discounts
|
| 83 |
AE_CHUNK_BY |
Character(20) |
VARCHAR2(20) NOT NULL |
Chunking Method
|
| 84 |
PP_COUNT |
Number(7,0) |
INTEGER NOT NULL |
Count
|
| 85 |
PP_L_STEP |
Number(3,0) |
SMALLINT NOT NULL |
Last Step
|
| 86 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 87 |
AE_STEP |
Character(8) |
VARCHAR2(8) NOT NULL |
Name
|
| 88 |
AE_DO_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Do Section
|
| 89 |
NEXT_AUTO_NUMBER |
Number(10,0) |
DECIMAL(10) NOT NULL |
Next Number for Auto Numbering
|
| 90 |
PP_L_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Last Bu
|
| 91 |
PP_L_CUST |
Character(15) |
VARCHAR2(15) NOT NULL |
Last Cust
|
| 92 |
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
|
| 93 |
AE_CNV_IN_FLD_NM |
Character(18) |
VARCHAR2(18) NOT NULL |
AE input convert field
|
| 94 |
AE_CNV_OUT_FLD_NM |
Character(18) |
VARCHAR2(18) NOT NULL |
AE output converion field
|
| 95 |
AE_CNV_JUSTIFY |
Character(1) |
VARCHAR2(1) NOT NULL |
AE Convert Justify Indicator
|
| 96 |
AE_STRIP_ZERO |
Character(1) |
VARCHAR2(1) NOT NULL |
AE Strip Zeros
|
| 97 |
GROUP_ID_SEQ_NUM |
Number(15,0) |
DECIMAL(15) NOT NULL |
Group ID
|
| 98 |
DEPOSIT_ID_SEQ_NUM |
Number(15,0) |
DECIMAL(15) NOT NULL |
Deposit ID Sequence Number
|
| 99 |
DECIMALPOS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|
| 100 |
AE_ROUND_INC |
Signed Number(8,5) |
DECIMAL(6,5) NOT NULL |
Rounding Increment
|
| 101 |
AE_INT_2 |
Number(2,0) |
SMALLINT NOT NULL |
Number Work Field
|
| 102 |
DST_ID_REAL |
Character(10) |
VARCHAR2(10) NOT NULL |
Specifies the general ledger ChartField combination for posting realized gain or loss calculated by the system during payment application or maintenance worksheet (Receivables).
|
| 103 |
DOC_SEQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Document Sequencing
|
| 104 |
DOC_TYPE |
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.
|
| 105 |
DOC_SEQ_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
|
| 106 |
DOC_SEQ_DATE |
Date(10) |
DATE |
Specifies the date that a document sequence number is assigned to a document or the date the document was created.
|
| 107 |
DOC_SEQ_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting.
1=Document Sequencing Disabled
A=GL BU Undefined
B=GL BU Blank
C=Accounting Date blank
D=Doc Type Blank
E=Jrnl Type, Code, Doc Undefine
F=Sequence Range Undefine
G=Max. Sequence Number Reached
H=Manual Nbr for Auto Doc Type
I=No Manual Number Entered
J=Duplicate Manual Number
K=Invalid Ledger
L=Invalid Ledger Group
N=No Status
|
| 108 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 109 |
ACTION_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Broadcast
D=log Deletedsequence number
E=Check doc seq enable option
G=Generate sequence number
R=Reset for 1099C Submission
X=Deleted from 1099C Prep Table
|
| 110 |
FIELDNAME_BU_GL |
Character(18) |
VARCHAR2(18) NOT NULL |
Business Unit GL Field Name
|
| 111 |
FIELDNAME_ACCTDATE |
Character(18) |
VARCHAR2(18) NOT NULL |
Accounting Date field name
|
| 112 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 113 |
RECNAME_XREF |
Character(15) |
VARCHAR2(15) NOT NULL |
Cross Reference Table
|
| 114 |
RETURN_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Return Code
0=Return OK
1=Return error
|
| 115 |
RUN_DT |
Date(10) |
DATE |
Run Date
|
| 116 |
WHERE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Where Option
B=Both
N=None
P=Process Instance
V=By Value
|
| 117 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 118 |
INV_TOL_AMT |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Invoice Tolerance Amount
|
| 119 |
INV_TOL_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Invoice Tolerance Percent
|
| 120 |
DISC_TOL_AMT |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Tolerance Amount
|
| 121 |
DISC_TOL_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Discount Tolerance Percent
|
| 122 |
DOCUMENT |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies a document used as a reference number for a Receivables item. Document ID is used by the Receivables Update program and the Maintenance Worksheet to "match" related invoices debit memos and credit memos.
|
| 123 |
DONE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Done Flag
|
| 124 |
ID_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Identification Sequence number
|
| 125 |
PAYMENT_DT |
Date(10) |
DATE |
Payment Date
|
| 126 |
PAYMENT_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the currency of a customer payment. This is generally the same as the currency specified for the deposit but it can be different.
|
| 127 |
SUBCUST_QUAL1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
|
| 128 |
SUBCUST_QUAL2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
|
| 129 |
REMIT_FROM_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 130 |
REMIT_FROM_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Remit From Customer
|
| 131 |
PYMT_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the type of exchange rate to be used when the currency of a customer payment is converted to the base currency of a business unit. The exchange rate type is also called the market rate type. Examples are spot rate current rate and official rate.
|
| 132 |
PYMT_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Specifies the number (the divisor) required to convert a payment amount from its entry currency to the business unit base currency. The number is based on the exchange rate specified for the transaction. It is used in conjunction with PYMT_RATE_MULT. Refer to documentation on the Triangulation Process for the exact calculation.
|
| 133 |
PYMT_RATE_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Specifies the number (the multiplier) required to convert a payment amount from its entry currency to the business unit base currency. The number is based on the exchange rate specified for the transaction. It is used in conjunction with PYMT_ RATE_DIV. Refer to documentation on the Triangulation Process for the exact calculation.
|
| 134 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 135 |
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.
|
| 136 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 137 |
REF_VALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
Reference
|
| 138 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 139 |
COUNTER1 |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Counter 1
|
| 140 |
COUNTER2 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Counter 2
|
| 141 |
REUSABLE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Reusable Item Flag
|
| 142 |
OC_SEQ_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Overdue Charge Sequence
|
| 143 |
EXCL_DED_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Deduction Items
|
| 144 |
EXCL_DISP_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Disputed Items
|
| 145 |
PARTITION1 |
Number(2,0) |
SMALLINT NOT NULL |
Parallel processing partition
|
| 146 |
PROCESS_INSTANCE2 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 147 |
AR_SPECIALIST |
Character(8) |
VARCHAR2(8) NOT NULL |
Accounts Recievable Specialist - person responsible for an action on an item.
|
| 148 |
COLLECTOR |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer to collect overdue payments.
|
| 149 |
CR_ANALYST |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer to establish credit limits and payment terms. This field is required for a bill-to customer.
|
| 150 |
SALES_PERSON |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer.
|
| 151 |
DEDUCTION_STATUS |
Character(5) |
VARCHAR2(5) NOT NULL |
Deduction Status
C=Closed
I=In Process
O=Created/Opened
W=On Worksheet
|
| 152 |
RATE_MULT_NEW |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Current Rate Multiplier
|
| 153 |
RATE_DIV_NEW |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Current Rate Divisor
|
| 154 |
RATE_DIV_2 |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 155 |
RATE_MULT_2 |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 156 |
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.
|
| 157 |
DISC_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Amt Base Curr
|
| 158 |
DISC_REAL_GAINLOSS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Real Gain Loss
|
| 159 |
REAL_GAIN_LOSS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the monetary amount of realized gain or loss calculated by the system during payment application or maintenance worksheet (Receivables).
|
| 160 |
CURRENCY_CD_2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency code 2
|
| 161 |
LENGTH |
Number(5,0) |
INTEGER NOT NULL |
Length
|
| 162 |
VAT_ENTITY |
Character(20) |
VARCHAR2(20) NOT NULL |
Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
|
| 163 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 164 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 165 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 166 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
|
| 167 |
VAT_SVC_PERFRM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Where VAT Services Physically Performed Flag
1=Ship To Location
2=Ship From Location
3=Buyer's Location
4=Supplier's Location
|
| 168 |
AR_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
A number that is assigned to draft items to ensure uniqueness of key
|
| 169 |
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
|
| 170 |
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.
|
| 171 |
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.
|
| 172 |
VAT_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
VAT Sequence Number
|
| 173 |
VAT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
VAT SetID
|
| 174 |
TXN_SEQ_NUM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Transaction Sequence number for TBP transactions
|
| 175 |
PP_OK |
Character(1) |
VARCHAR2(1) NOT NULL |
ok
|
| 176 |
BU_COUNT |
Number(5,0) |
INTEGER NOT NULL |
Count of business units
|
| 177 |
CUST_COUNT |
Number(5,0) |
INTEGER NOT NULL |
Count of customers
|
| 178 |
RECNAME_PYMNT |
Character(15) |
VARCHAR2(15) NOT NULL |
RECNAME PYMNT
|
| 179 |
RECNAME_MATCH |
Character(15) |
VARCHAR2(15) NOT NULL |
RECNAME MATCH
|
| 180 |
AE_WHERE |
Character(254) |
VARCHAR2(254) NOT NULL |
AE Generic Where Clause
|
| 181 |
CHECK_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Work field used to store status values
|
| 182 |
WO_ITEM_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Write Off Item
|
| 183 |
ALGORITHM1 |
Character(7) |
VARCHAR2(7) NOT NULL |
Algorithm Identifier
|
| 184 |
FIELDNAME1 |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name 1
|
| 185 |
WHERE_CLAUSE1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 186 |
WHERE_CLAUSE2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 187 |
WHERE_CLAUSE3 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 188 |
WHERE_CLAUSE_LONG |
Long Character(4000) |
CLOB |
Where Clause
|
| 189 |
FST8MID7_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
First 8 mid 7 algorithm flag
|
| 190 |
PP_CC_UNSEL_CNT |
Number(7,0) |
INTEGER NOT NULL |
Count of items that are not budget checked
|
| 191 |
SETID1 |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID Value
|
| 192 |
AR_PARENTC_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 193 |
AR_PARENTC_CUSTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Cust ID
|
| 194 |
AR_FULL_HIERARCHY |
Character(1) |
VARCHAR2(1) NOT NULL |
AR_FULL_HIERARCHY CHAR 1
|
| 195 |
MICR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
MICR ID
|
| 196 |
HIERARCHY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Hierarchy Type
C=Corporate
R=Remit From
|
| 197 |
PAYMENT_AMT_TOTAL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of a customer payment.
|
| 198 |
PP_ITEM_USED |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Used
Default Value: N
|
| 199 |
ITEM_NEW_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Partial sell/buyback amount
|