| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 CA_TXN_ID |
Number(12,0) |
DECIMAL(12) NOT NULL |
Transaction ID
|
| 2 |
TRANS_TYPE_BI |
Character(4) |
VARCHAR2(4) NOT NULL |
Transaction Type
AE=Accounting Entry
AHDR=Adjustment Header
DDS=Deferred Discount/Surcharge
DS=Discount/Surcharge
EXSD=Indian Excise/Sales Tax Detail
LINE=Chargeable Line
NOTE=Note/Comment
TAX=Sales/Use Tax Detail
|
| 3 |
TRANS_TYPE_BI_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Transaction Type Seq
010=Invalid Transaction Type
020=Too many charge lines
030=No charge line for activity
040=Invalid Business Unit
050=Invalid bill-to customer
060=Invalid Billing Address
070=Invalid bill-to contact
080=No Bill Source provided
090=Invalid Bill Source
100=Invalid Bill Type
110=Invalid Bill Cycle
120=Invalid Payment Term
130=Invalid Tax Code
140=Invalid Unit of measure
200=Invalid Standard Note Code
210=No Note Code or Text exists
300=Both Amount & Percentage are 0
|
| 4 |
HDR_FIELDS_KEY |
Character(30) |
VARCHAR2(30) NOT NULL |
Header Fields Key
|
| 5 |
HDR_FIELDS_BILL_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
Header Fields Bill By
|
| 6 |
ADJ_TRANS_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Adjustment Transaction Type
|
| 7 |
CREATE_NEW_BILL |
Character(1) |
VARCHAR2(1) NOT NULL |
Create New Bill
Y/N Table Edit
Default Value: N
|
| 8 |
TMP_BILL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Bill
Y/N Table Edit
Default Value: N
|
| 9 |
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.
Prompt Table:
ENTRY_TYPE_TBL
|
| 10 |
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""."
Prompt Table:
ENTRY_REASN_TBL
|
| 11 |
ENTRY_EVENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Entry Event
Prompt Table:
EE_AR_CODE1_VW
|
| 12 |
LOAD_STATUS_BI |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Interface Load Status
DON=Done (Complete)
ERR=Error
NEW=New
RDY=Ready
UPD=Updating
|
| 13 |
ERROR_STATUS_BI |
Character(4) |
VARCHAR2(4) NOT NULL |
Error Status
|
| 14 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_BI_NONVW
|
| 15 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table:
SP_BU_GL_NONVW
|
| 16 |
BILL_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer
Prompt Table:
BI_BILL_TO_VW
|
| 17 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
Prompt Table:
BI_CUST_ADDR_VW
|
| 18 |
BILL_TO_COPIES |
Number(3,0) |
SMALLINT NOT NULL |
Number of Copies
Default Value: 1
|
| 19 |
CNTCT_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Contact Sequence Number
Prompt Table:
CUST_CNCT_BI_VW
|
| 20 |
NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1
|
| 21 |
INTERUNIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
InterUnit
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 22 |
BUSINESS_UNIT_TO |
Character(5) |
VARCHAR2(5) NOT NULL |
04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT
Prompt Table:
SP_BU_GL_NONVW
|
| 23 |
DIRECT_INVOICING |
Character(1) |
VARCHAR2(1) NOT NULL |
Direct Invoicing
Y/N Table Edit
Default Value: N
|
| 24 |
RANGE_SELECTION_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Range Selection ID
|
| 25 |
BILL_SOURCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Source
Prompt Table:
BI_SRC_EF_VW
|
| 26 |
BILL_TYPE_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Bill Type Identifier
Prompt Table:
BI_TYPE_EF_VW
|
| 27 |
BILL_CYCLE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Cycle Identifier
Prompt Table:
BI_CYCLE_VW
|
| 28 |
BILL_BY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill By Identifier
Prompt Table:
BI_BILL_BY
|
| 29 |
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
|
| 30 |
PYMNT_TERMS_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
Prompt Table:
AR_TRMS_VW
|
| 31 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
BANK_BI_BR_VW
|
| 32 |
BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
Prompt Table:
BI_BANK_R_VW
|
| 33 |
BI_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Currency Code
|
| 34 |
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. "
|
| 35 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table:
RT_TYPE_TBL
|
| 36 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 37 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 38 |
CUR_RT_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Exchange Rate Source
T=Use Exchange Rate Tables
U=User Specified
|
| 39 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 40 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 41 |
ACCRUE_UNBILLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Accrue Bills of This Level
Y/N Table Edit
|
| 42 |
TARGET_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Target Invoice
|
| 43 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 44 |
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.
Prompt Table:
BI_DOC_TYPE_VW
|
| 45 |
CONSOL_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Consolidation Customer SetID
Prompt Table:
SP_SETID_NONVW
|
| 46 |
CONSOL_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Consolidation Customer ID
Prompt Table:
CUST_CONSOL_VW
|
| 47 |
CONSOL_KEY |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice Consolidation Key
|
| 48 |
INVOICE_TO_ADJ |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice To Adjust
Prompt Table:
BI_HDR_NOADH_VW
|
| 49 |
ADJ_DELTA_ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Adjustment Delta Action
ADD=Add
DEL=Delete
RPL=Replace
|
| 50 |
LINE_SEQ_TO_ADJ |
Number(5,0) |
INTEGER NOT NULL |
Line Sequence To Adjust
|
| 51 |
LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 52 |
LINE_DST_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Revenue Sequence Number
|
| 53 |
LINE_DFR_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Deferred Sequence Number
|
| 54 |
LINE_UAR_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Unbilled AR Sequence Number
|
| 55 |
LAST_NOTE_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Last note sequence number
|
| 56 |
NOTES_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Notes Sequence Num
|
| 57 |
LINE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Line Type 1
ADV=Advance Billing
BAE=Billed Amount in Excess
BRT=Billing Retainage
DAPP=Cust Deposit Applied
DEP=Customer Deposit
DISC=Discount Line
DREF=Cust Deposit Refunded
DRFF=Cust Deposit Refund Fee
FRGT=Freight (Surcharge)
MISC=Miscellaneous Charge
PYCV=Payment with Corporate Voucher
RAE=Reclaimed Amount in Excess
REV=Revenue Line
RSTK=Restock (Surcharge)
SUR=Surcharge Line
UTL=Utilization Line
|
| 58 |
IDENTIFIER |
Character(18) |
VARCHAR2(18) NOT NULL |
Identifier
|
| 59 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 60 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table:
UNITS_TBL
|
| 61 |
QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity
|
| 62 |
ORIG_QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Original Quantity
|
| 63 |
UNIT_AMT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Unit Price
|
| 64 |
LIST_PRICE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
List Price
|
| 65 |
PPRC_PROMO_CD |
Character(20) |
VARCHAR2(20) NOT NULL |
Price Promotion Code
|
| 66 |
MERCH_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Merchandising Type
|
| 67 |
TAX_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Tax Code
Prompt Table:
TAX_SU_HDR_VW
|
| 68 |
TAX_EXEMPT_CERT |
Character(30) |
VARCHAR2(30) NOT NULL |
Exemption Certificate
Prompt Table:
BI_CUST_EXMPTVW
|
| 69 |
TAX_EXEMPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Flag
Y/N Table Edit
|
| 70 |
TAX_EXEMPT_RC |
Character(2) |
VARCHAR2(2) NOT NULL |
Exempt Reason Code
01=Certificat
|
| 71 |
TAX_JOB_NUM |
Character(10) |
VARCHAR2(10) NOT NULL |
Job Number
|
| 72 |
BI_TAX_TIMING |
Character(1) |
VARCHAR2(1) NOT NULL |
BI Tax Timing
S=Tax on Services Rendered
|
| 73 |
CUSTOMER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Customer Group
|
| 74 |
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.
Prompt Table:
VAT_TXN_CD
Set Control Field: BUSINESS_UNIT
|
| 75 |
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.
Prompt Table:
VAT_HEADER_VW
Set Control Field: BUSINESS_UNIT
|
| 76 |
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
|
| 77 |
VAT_PRODUCT_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Product Group
|
| 78 |
PROD_GRP_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Product Group SetID
Prompt Table:
SP_SETID_NONVW
|
| 79 |
IST_TXN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrastat Transaction Flag
N=No
Y=Yes
|
| 80 |
IDENTIFIER_TBL |
Character(3) |
VARCHAR2(3) NOT NULL |
Table Identifier
A=Asset ID
CON=Contracts
D=Discount Table
G=Generic Identifier
ID=PS/Billing Charge Id
ITM=PS/Inventory Item ID
LAB=Labor type
PDA=Product Alias
PRD=PS/Product Id
PRM=PS/Promotion Code
S=Surcharge Table
SVC=Service
UPC=UPC
UPN=Universal Item ID
|
| 81 |
SHIP_FROM_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship From Location
Prompt Table:
LOCATION_TBL
|
| 82 |
ORD_ACCEPT_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Order Acceptance
Prompt Table:
LOCATION_TBL
|
| 83 |
ORD_ORIGIN_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Order Origin
Prompt Table:
LOCATION_TBL
|
| 84 |
STORE_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Store Location
|
| 85 |
TITLE_PASSAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Title Passage
B=Buyer's Destination-Ship To
I=Intermediate Consignee
S=Seller's Origination-Ship From
|
| 86 |
TAX_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Group
|
| 87 |
TAX_USER_AREA |
Character(25) |
VARCHAR2(25) NOT NULL |
Used for tax calculation by tax vendor.
|
| 88 |
TAX_TRANS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Type
1=Sale
2=Rental
3=Service
4=Purchase
5=Lease
B=Return
|
| 89 |
TAX_TRANS_SUB_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Sub Type
1=Property
2=Freight
3=Service
4=Rental or Lease
5=Expense
6=Misc
N=None
|
| 90 |
NET_EXTENDED_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Net Extended Amt
|
| 91 |
GROSS_EXTENDED_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Extended
|
| 92 |
REV_RECOG_BASIS |
Character(3) |
VARCHAR2(3) NOT NULL |
Revenue Recognition Basis
CHG=From/To Date Range
CON=Contract Date
INV=Invoice Date
ORD=Order Date
SHP=Ship Date
STE=Start/End Date Range
UD1=User Date 1
UD2=User Date 2
|
| 93 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
BI_PROJ_BUGL_VW
|
| 94 |
BUSINESS_UNIT_OM |
Character(5) |
VARCHAR2(5) NOT NULL |
Order Management Business Unit
Prompt Table:
SP_BU_OM_NONVW
|
| 95 |
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
Prompt Table:
BI_ORD_HDR_VW
|
| 96 |
ORDER_INT_LINE_NO |
Number(5,0) |
INTEGER NOT NULL |
Order Line
|
| 97 |
SCHED_LINE_NBR |
Number(6,0) |
INTEGER NOT NULL |
Schedule Line Number
|
| 98 |
DEMAND_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
|
| 99 |
DEMAND_LINE_NO |
Number(4,0) |
SMALLINT NOT NULL |
Demand Line No
|
| 100 |
BUSINESS_UNIT_RMA |
Character(5) |
VARCHAR2(5) NOT NULL |
RMA Business Unit
Prompt Table:
SP_BU_OM_NONVW
|
| 101 |
RMA_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
RMA Number
Prompt Table:
BI_RMA_HDR_VW
|
| 102 |
RMA_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
RMA Line Number
|
| 103 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
Prompt Table:
BI_PROD_ITEM_VW
|
| 104 |
ORDER_DATE |
Date(10) |
DATE |
Date Initials Issue Description
022701 mv SP2 (F-CJORGENS-3) CSR Desktop
|
| 105 |
PO_REF |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the purchase order number associated with a receivables item.
|
| 106 |
PO_LINE |
Number(3,0) |
SMALLINT NOT NULL |
Specifies the line number of a purchase order associated with a receivables item. It is used with the field PO_REF.
|
| 107 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
|
| 108 |
CONTRACT_DT |
Date(10) |
DATE |
Contract Date
|
| 109 |
CONTRACT_TYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Contract Type
|
| 110 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|
| 111 |
FREIGHT_TERMS |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Terms Code
Prompt Table:
FREIGHT_TERMS
|
| 112 |
BILL_OF_LADING |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies a bill of lading number associated with a Receivables item.
|
| 113 |
COUNTRY_SHIP_FROM |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country from which the invoice contents were shipped (for VAT processing only).
Prompt Table:
COUNTRY_TBL
|
| 114 |
COUNTRY_SHIP_TO |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country to which the invoice contents were shipped (for VAT processing only).
Prompt Table:
COUNTRY_TBL
|
| 115 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
Prompt Table:
BI_SHIP_TO_VW
|
| 116 |
SHIP_TO_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Ship To Address Sequence Num
Prompt Table:
BI_SHP_ADDR_VW
|
| 117 |
SHIP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shipping ID
|
| 118 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table:
SHIP_METHOD
|
| 119 |
SHIP_FROM_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Ship from INV BU
|
| 120 |
SHIP_DATE |
Date(10) |
DATE |
Item Shipping Date
|
| 121 |
SHIP_TIME |
Time(15) |
TIMESTAMP |
Ship Time
|
| 122 |
PACKSLIP_NO |
Character(22) |
VARCHAR2(22) NOT NULL |
Packing Slip Number
|
| 123 |
LC_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Treasury Letter of Credit Number Assigned by the System
|
| 124 |
LOC_DOC_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Letter of Credit Document ID
|
| 125 |
SEQUENCE_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 126 |
SOLD_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sold To Customer
Prompt Table:
BI_SOLD_TO_VW
|
| 127 |
SOLD_TO_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sold To Address Sequence Num
Prompt Table:
BI_SLD_ADDR_VW
|
| 128 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table:
SP_BU_PC_NONVW
|
| 129 |
BUSINESS_UNIT_CA |
Character(5) |
VARCHAR2(5) NOT NULL |
Contracts Business Unit
|
| 130 |
RT_EFFDT |
Date(10) |
DATE |
The effective date for a given item of market rate data.
|
| 131 |
BILL_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Plan ID
|
| 132 |
PC_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
PC Distribution Status
B=Budget Check
D=Distributed
G=Generated
H=Hold
I=Ignore
M=Modified
N=Not Distributed
S=Staged
|
| 133 |
BPLAN_LN_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Bill Plan Line Number
|
| 134 |
EVENT_OCCURRENCE |
Number(3,0) |
SMALLINT NOT NULL |
Identifies a user-defined event on a schedule for automatically creating standard and recurring journal entries. Event Occurrence is a number associated with a date for creation of the journal.
|
| 135 |
XREF_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Cross Reference Sequence No.
|
| 136 |
CONTRACT_PPD_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Prepaid Add Sequence
|
| 137 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table:
PROJ_ANTYPE_FS
|
| 138 |
RESOURCE_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
Transaction ID
|
| 139 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
Prompt Table:
PROJ_RESTYPE_FS
|
| 140 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
Prompt Table:
PROJ_RESCAT_FS
|
| 141 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table:
PROJ_SUBCAT_FS
|
| 142 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
PROJ_ACT_FS
|
| 143 |
ACTIVITY_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Activity Type
A=Activity Type
E=Entry Type
G=Group Type/Origin
O=Activity Type/Origin
R=Entry Type/Reason
|
| 144 |
DIST_CFG_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribution Configuration
|
| 145 |
PRODUCT_KIT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product Kit Number
|
| 146 |
SYSTEM_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the application or source system that generated a journal entry.
Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values.
SUJ---Included a label as Product.
Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
|
| 147 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 148 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 149 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 150 |
END_DT |
Date(10) |
DATE |
End Date
|
| 151 |
FROM_DT |
Date(10) |
DATE |
From Date
|
| 152 |
TO_DT |
Date(10) |
DATE |
To Date
|
| 153 |
SERVICE_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Service Customer ID
Prompt Table:
CUSTOMER
|
| 154 |
SERVICE_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Service Address Num
Prompt Table:
BI_SVC_ADDR_VW
|
| 155 |
NOTE_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Note Type
Prompt Table:
NOTE_TYPE_EF_VW
|
| 156 |
STD_NOTE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Standard Note Flag
N=No
Y=Yes
|
| 157 |
INTERNAL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Internal Only Flag
N=No
Y=Yes
|
| 158 |
HDR_OR_LINE_NOTE |
Character(1) |
VARCHAR2(1) NOT NULL |
Header or Line Note
H=Header Note
L=Line Note
|
| 159 |
AR_LVL |
Character(1) |
VARCHAR2(1) NOT NULL |
AR Level
H=Header is AR Open Item
L=Bill Line is AR Open Item
N=No AR Open Items
|
| 160 |
AR_DST_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
AR Distribution Option
H=Use Header for Distribution
L=Use Line for Distribution
|
| 161 |
GL_LVL |
Character(1) |
VARCHAR2(1) NOT NULL |
GL Level
A=AR Creates GL Acct Entries
B=BI Creates GL Acct Entries
N=No GL Accounting Entries
|
| 162 |
ENABLE_DFR_REV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Deferred Revenues
|
| 163 |
BILLING_SPECIALIST |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Specialist
Prompt Table:
BI_SPECIALST_VW
|
| 164 |
BILLING_AUTHORITY |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Authority
Prompt Table:
BI_AUTHORITY_VW
|
| 165 |
BILLING_FREQUENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Frequency
INS=Installment
ONC=Once
REC=Recurring
|
| 166 |
BILL_INQUIRY_PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Bill Inquiry Phone
Prompt Table:
BI_INQPHONE_VW
|
| 167 |
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.
Prompt Table:
TEAM_MEMBER_VW
Set Control Field: BUSINESS_UNIT
|
| 168 |
COLLECTOR |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer to collect overdue payments.
Prompt Table:
COLLECTOR_TBL
|
| 169 |
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.
Prompt Table:
CR_ANALYST_TBL
|
| 170 |
INVOICE_FORM_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Invoice Form
Prompt Table:
BI_IVC_FORM_VW
|
| 171 |
STD_NOTE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Standard Note Code
Prompt Table:
BI_STD_NOTE_VW
|
| 172 |
TOT_LINE_DST_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Line Dist Amount
|
| 173 |
TOT_LINE_DST_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Total Revenue Percent
|
| 174 |
TOT_LINE_DFR_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Total Deferred Percent
|
| 175 |
TOT_LINE_DFR_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Line Deferred Amount
|
| 176 |
TOT_LINE_UAR_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Line Unbilled AR Amount
|
| 177 |
TOT_LINE_UAR_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Total Unbilled AR Percent
|
| 178 |
SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Social Security #
|
| 179 |
CHARGE_FROM_DT |
Date(10) |
DATE |
From Date for line charges
|
| 180 |
CHARGE_TO_DT |
Date(10) |
DATE |
Through date for charges
|
| 181 |
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.
Prompt Table:
SUBCUST_Q1_TBL
|
| 182 |
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.
Prompt Table:
SUBCUST_Q2_TBL
|
| 183 |
REIMB_AGREEMENT |
Character(25) |
VARCHAR2(25) NOT NULL |
Date Init. Issue # Description
09/25/01 JJM DI-EDWONG-17 Created field to replace CONTRACT_NUM in certain records
|
| 184 |
TOT_DISCOUNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Amt
|
| 185 |
TOT_SURCHARGE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Surcharge Amt
|
| 186 |
ACCUMULATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Include in Cumulative Balance
Y/N Table Edit
|
| 187 |
VAT_TREATMENT_GRP |
Character(4) |
VARCHAR2(4) NOT NULL |
VAT Treatment Group
Prompt Table:
BI_VT_TRMTG_VW
|
| 188 |
COUNTRY_VAT_BILLFR |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country where an invoice is generated (for VAT processing only).
|
| 189 |
COUNTRY_VAT_BILLTO |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country where an invoice is sent (for VAT processing only).
|
| 190 |
VAT_TREATMENT |
Character(4) |
VARCHAR2(4) NOT NULL |
VAT Treatment
Prompt Table:
BI_VT_TREAT_VW
|
| 191 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
|
| 192 |
COUNTRY_LOC_BUYER |
Character(3) |
VARCHAR2(3) NOT NULL |
Buyer's Location Country - May be either the VAT Entity or the Trading Partner
|
| 193 |
STATE_LOC_BUYER |
Character(6) |
VARCHAR2(6) NOT NULL |
Buyer's Location State - May be either the VAT Entity or the Trading Partner
|
| 194 |
COUNTRY_LOC_SELLER |
Character(3) |
VARCHAR2(3) NOT NULL |
Seller's Location Country - May be either the VAT Entity or the Trading Partner
|
| 195 |
STATE_LOC_SELLER |
Character(6) |
VARCHAR2(6) NOT NULL |
Seller's Location State - May be either the VAT Entity or the Trading Partner
|
| 196 |
VAT_SVC_SUPPLY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Services Place of Supply Flag
1=Supplier's Countries
2=Buyer's Countries
3=Where Physically Performed
|
| 197 |
VAT_SERVICE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Service Type
1=Freight Transport
2=Other
3=Electronics/Communication
|
| 198 |
COUNTRY_VAT_PERFRM |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Where Service Physically Performed
|
| 199 |
STATE_VAT_PERFRM |
Character(6) |
VARCHAR2(6) NOT NULL |
State Where Service Physically Performed
|
| 200 |
COUNTRY_VAT_SUPPLY |
Character(3) |
VARCHAR2(3) NOT NULL |
VAT Place of Supply Country
|
| 201 |
STATE_VAT_SUPPLY |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Place of Supply State
|
| 202 |
STATE_SHIP_FROM |
Character(6) |
VARCHAR2(6) NOT NULL |
Ship From State
|
| 203 |
STATE_SHIP_TO |
Character(6) |
VARCHAR2(6) NOT NULL |
Ship To State
|
| 204 |
MAST_CONTR_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Master Contract #
|
| 205 |
TAX_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Tax Customer ID
|
| 206 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
|
| 207 |
BUSINESS_UNIT_AMTO |
Character(5) |
VARCHAR2(5) NOT NULL |
Asset Business Unit To
|
| 208 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 209 |
PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Profile ID
|
| 210 |
COST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Type
|
| 211 |
STATE_VAT_DEFAULT |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Defaulting State
|
| 212 |
SO_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Service Order ID
|
| 213 |
BUSINESS_UNIT_RF |
Character(5) |
VARCHAR2(5) NOT NULL |
Field Services Business Unit
|
| 214 |
SOURCE_REF_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Generice reference type
001=CRM Agreement
002=CRM Case
003=CRM Order
004=CRM Service Order
005=Accounts Receivable
006=Billing
007=Order Management
|
| 215 |
SOURCE_REF_NO |
Character(35) |
VARCHAR2(35) NOT NULL |
Generic reference number
|
| 216 |
SOURCE_REF_KEY |
Character(5) |
VARCHAR2(5) NOT NULL |
Additional key for generic reference. May be populated with business unit, setid, or other key value.
|
| 217 |
USER_AMT1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8)
|
| 218 |
USER_AMT2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8)
|
| 219 |
USER_DT1 |
Date(10) |
DATE |
Specifies an additional date associated with a pending receivables item. This field is customizable and user-defined and is one of four user date fields (USER_DT1 through USER_DT4).
|
| 220 |
USER_DT2 |
Date(10) |
DATE |
Specifies an additional date associated with a pending receivables item. This field is customizable and user-defined and is one of four user date fields (USER_DT1 through USER_DT4).
|
| 221 |
USER1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
|
| 222 |
USER2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
|
| 223 |
USER3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
|
| 224 |
USER4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
|
| 225 |
USER5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
|
| 226 |
USER6 |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
|
| 227 |
USER7 |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
|
| 228 |
USER8 |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
|
| 229 |
USER9 |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
|
| 230 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 231 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 232 |
ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Date Time Added
|
| 233 |
LAST_UPDATE_DTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|