| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 3 |
SETID1 |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID Value
|
| 4 |
SETID2 |
Character(5) |
VARCHAR2(5) NOT NULL |
2nd SetId
|
| 5 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 6 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 7 |
BILL_BY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill By Identifier
|
| 8 |
BILL_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer
|
| 9 |
PAYMENT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft.
10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH
CC=Credit Card
CHK=Check
CSH=Cash
DD=Direct Debit
DR=Draft
EC=Electronic Check
EFT=Electronic Fund Transfer
GE=Giro - EFT
PL=PayPal
WIR=Wire Report
|
| 10 |
BI_RECCOUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
BI Rec Count
|
| 11 |
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. "
|
| 12 |
BASE_CURRENCY_TO |
Character(3) |
VARCHAR2(3) NOT NULL |
Base Currency To
|
| 13 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 14 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
|
| 15 |
BAL_ACCUM_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Balance Accumulation ID
|
| 16 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 17 |
BI_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Currency Code
|
| 18 |
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.
|
| 19 |
CUSTOMER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Customer Group
|
| 20 |
BUSINESS_UNIT_OM |
Character(5) |
VARCHAR2(5) NOT NULL |
Order Management Business Unit
|
| 21 |
RMA_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
RMA Number
|
| 22 |
RMA_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
RMA Line Number
|
| 23 |
RMA_DATE |
Date(10) |
DATE |
RMA Date
|
| 24 |
RETURN_TO_IBU |
Character(5) |
VARCHAR2(5) NOT NULL |
Return To IBU
|
| 25 |
RETURN_FR_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Return From Cust ID
|
| 26 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 27 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 28 |
REASON_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Reason Code
|
| 29 |
TOTAL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply to Total
|
| 30 |
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.
|
| 31 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 32 |
LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 33 |
COUNTRY_SHIP_TO |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country to which the invoice contents were shipped (for VAT processing only).
|
| 34 |
COUNTRY_SHIP_FROM |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country from which the invoice contents were shipped (for VAT processing only).
|
| 35 |
BUSINESS_UNIT_AR |
Character(5) |
VARCHAR2(5) NOT NULL |
AR Business Unit
|
| 36 |
TAX_COMPANY |
Character(5) |
VARCHAR2(5) NOT NULL |
Company for Tax Suppliers
|
| 37 |
TAX_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Group
|
| 38 |
INVOICE_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount
|
| 39 |
INVOICE_AMT_PRETAX |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Pretax Invoice Amount
|
| 40 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 41 |
CONSOL_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the Billing business unit associated with a consolidated bill.
|
| 42 |
CONSOL_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Specifies the invoice identifier associated with a consolidated bill.
|
| 43 |
ORIGIN_ID_BILLING |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Origin ID
|
| 44 |
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.
|
| 45 |
GROUP_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Represents the high level grouping of multiple general ledger business units.
|
| 46 |
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.
|
| 47 |
CNTCT_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Contact Sequence Number
|
| 48 |
COMMITMENT_CNTL_BI |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control on BI
|
| 49 |
ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Date Time Added
|
| 50 |
PROCESS_INSTANCE2 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 51 |
INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Interface ID
|
| 52 |
INTFC_LINE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Interface Line Number
|
| 53 |
HDR_FIELDS_KEY |
Character(30) |
VARCHAR2(30) NOT NULL |
Header Fields Key
|
| 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 |
BUDGET_PERIOD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Budget Period
|
| 56 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 57 |
IU_LEGAL_ENT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Legal Entity for InterUnit
|
| 58 |
IU_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
InterUnit Method
D=Direct
I=Indirect
P=Pairs
|
| 59 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 60 |
BUSINESS_UNIT_TO |
Character(5) |
VARCHAR2(5) NOT NULL |
04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT
|
| 61 |
IU_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Used for interunit bill options, to distinguish the different types of inter/intraunit entries.
AE=IntraEntity
AU=IntraUnit
IE=InterEntity
IU=InterUnit
|
| 62 |
GEN_AR_ITEM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate AR Open Item
|
| 63 |
GEN_AP_VCHR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate AP Voucher
|
| 64 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 65 |
FIELDNAME_SUFFIX |
Character(18) |
VARCHAR2(18) NOT NULL |
FIELDNAME WITH A SUFFIX
|
| 66 |
CFSTRING1 |
Long Character(1000) |
VARCHAR2(1000) |
ChartField String
|
| 67 |
CFSTRING2 |
Long Character(1000) |
VARCHAR2(1000) |
ChartField String
|
| 68 |
UPGRADE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Upgrade Type
A=All
C=Current
H=History
|
| 69 |
CUTOFF_DT |
Date(10) |
DATE |
The settlement cutoff date for a given bank/counterparty.
|
| 70 |
SOURCE_LEGAL_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Legal Entity
|
| 71 |
DESTIN_LEGAL_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Destination Legal Entity
|
| 72 |
UPG_RELEASE |
Character(4) |
VARCHAR2(4) NOT NULL |
Upgrade Application Release
751=7.51 Release
752=7.52 Release
753=7.53 Release
801=8 SP1 Release
803=8 SP3 Release
840=8.40 Release
841=8.40 SP1
880=8.80 Release
|
| 73 |
FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag
N=No
Y=Yes
|
| 74 |
IU_TRAN_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction.
|
| 75 |
IU_INTRA_TMPLT_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Key field for IntraUnit Template
|
| 76 |
IU_INTER_TMPLT_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Key to the interunit template record. Assigned to a GLBU on the GL business unit table.
|
| 77 |
IU_INTER_TMPLT_CD1 |
Character(5) |
VARCHAR2(5) NOT NULL |
Key to the interunit template record. Assigned to a GLBU on the GL business unit table.
|
| 78 |
IU_INTER_TMPLT_CD2 |
Character(5) |
VARCHAR2(5) NOT NULL |
Key to the interunit template record. Assigned to a GLBU on the GL business unit table.
|
| 79 |
ACT_BAL_GRP |
Character(10) |
VARCHAR2(10) NOT NULL |
Account Balancing Group
|
| 80 |
COUNTER1 |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Counter 1
|
| 81 |
DISC_SUR_LVL |
Number(2,0) |
SMALLINT NOT NULL |
Discount/Surcharge Level
|
| 82 |
DISC_SUR_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Identifier
|
| 83 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 84 |
BILL_TYPE_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Bill Type Identifier
|
| 85 |
BILL_SOURCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Source
|
| 86 |
CURRENCY_CD_XEU |
Character(3) |
VARCHAR2(3) NOT NULL |
Euro Currency
|
| 87 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 88 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
|
| 89 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|
| 90 |
IU_ENTRY_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Entry Type
AEAP=IntraEntity Accrued Payable
AECG=IntraEntity Cost of Goods
AECS=IntraEntity Customer Shipments
AEEX=IntraEntity Expense
AEPY=IntraEntity Payable
AERC=IntraEntity Receivable
AERV=IntraEntity Revenue
AETR=IntraEntity In Transit
AUEX=IntraUnit Expense
AUPY=IntraUnit Payable
AURC=IntraUnit Receivable
AURV=IntraUnit Revenue
AUTR=IntraUnit In Transit
IEAP=InterEntity Accrued Payable
IECG=InterEntity Cost of Goods
IECS=InterEntity Customer Shipments
IEEX=InterEntity Expense
IEPY=InterEntity Payable
IERC=InterEntity Receivable
IERV=InterEntity Revenue
IETR=InterEntity In Transit
IUAP=InterUnit Accrued Payable
IUCG=InterUnit Cost of Goods
IUCS=InterUnit Customer Shipments
IUEX=InterUnit Expense
IUPY=InterUnit Payable
IURC=InterUnit Receivable
IURV=InterUnit Revenue
IUTR=InterUnit In Transit
|
| 91 |
LC_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Treasury Letter of Credit Number Assigned by the System
|
| 92 |
LOC_DOC_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Letter of Credit Document ID
|
| 93 |
COLLECTOR |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer to collect overdue payments.
|
| 94 |
VAT_TREATMENT |
Character(4) |
VARCHAR2(4) NOT NULL |
VAT Treatment
|
| 95 |
VAT_TREATMENT_GRP |
Character(4) |
VARCHAR2(4) NOT NULL |
VAT Treatment Group
|
| 96 |
COUNTRY_VAT_BILLFR |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country where an invoice is generated (for VAT processing only).
|
| 97 |
COUNTRY_VAT_BILLTO |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country where an invoice is sent (for VAT processing only).
|
| 98 |
COUNTRY_LOC_BUYER |
Character(3) |
VARCHAR2(3) NOT NULL |
Buyer's Location Country - May be either the VAT Entity or the Trading Partner
|
| 99 |
COUNTRY_LOC_SELLER |
Character(3) |
VARCHAR2(3) NOT NULL |
Seller's Location Country - May be either the VAT Entity or the Trading Partner
|
| 100 |
COUNTRY_VAT_PERFRM |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Where Service Physically Performed
|
| 101 |
STATE_LOC_BUYER |
Character(6) |
VARCHAR2(6) NOT NULL |
Buyer's Location State - May be either the VAT Entity or the Trading Partner
|
| 102 |
STATE_LOC_SELLER |
Character(6) |
VARCHAR2(6) NOT NULL |
Seller's Location State - May be either the VAT Entity or the Trading Partner
|
| 103 |
STATE_VAT_PERFRM |
Character(6) |
VARCHAR2(6) NOT NULL |
State Where Service Physically Performed
|
| 104 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
|
| 105 |
SHIP_TO_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Ship To Address Sequence Num
|
| 106 |
FORWARD_BAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Forwarding Balance
|
| 107 |
PAID_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Paid Amount
|
| 108 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 109 |
SHIP_FROM_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Ship from INV BU
|
| 110 |
INVOICE_LINE |
Number(5,0) |
INTEGER NOT NULL |
Invoice Line
|
| 111 |
COUNTER |
Number(10,0) |
DECIMAL(10) NOT NULL |
Counter
|
| 112 |
USE_CONTROL_BUDG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Controlled Budgeting?
|
| 113 |
CF_ORDER |
Number(2,0) |
SMALLINT NOT NULL |
ChartField Sequence Order
|
| 114 |
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.
|
| 115 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 116 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 117 |
CHG_DATE |
Date(10) |
DATE |
Change Date
|
| 118 |
PPRC_PROMO_CD |
Character(20) |
VARCHAR2(20) NOT NULL |
Price Promotion Code
|
| 119 |
MERCH_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Merchandising Type
|
| 120 |
USETAX_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Use Tax Basis Amount
|
| 121 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 122 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|