| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_BI_NONVW
|
| 2 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
Default Value: NEXT
Prompt Table:
BI_HDR
|
| 3 |
BILL_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer
Prompt Table:
BI_BILLTO_IU_VW
|
| 4 |
BILL_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Bill Status
CAN=Canceled
FNL=Finalized Bill
HLD=Hold Bill
INV=Invoiced Bill
NEW=New Bill
PND=Pending Approval
RDY=Ready to Invoice
TMP=Temporary Bill
TMR=Temporary Ready Bill
Default Value: NEW
|
| 5 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
Prompt Table:
CA_HDR_ACT_VW
|
| 6 |
INVOICE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Invoice Type
ACR=Credit Bill
ADJ=Adjustment Only bill
ARB=Rebill Bill
PRF=Pro Forma Invoice
RAD=Regular bill with adjustments
REG=Regular Bill
Default Value: REG
|
| 7 |
BILL_TYPE_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Bill Type Identifier
Prompt Table:
BI_TYPE_EF_VW
|
| 8 |
BILL_SOURCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Source
Prompt Table:
BI_SRC_EF_VW
|
| 9 |
BILL_CYCLE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Cycle Identifier
Prompt Table:
BI_CYCLE_VW
|
| 10 |
FROM_DT |
Date(10) |
DATE |
From Date
|
| 11 |
TO_DT |
Date(10) |
DATE |
To Date
|
| 12 |
BUSINESS_UNIT_TO |
Character(5) |
VARCHAR2(5) NOT NULL |
04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT
Prompt Table:
SP_BIIUP_NONVW
|
| 13 |
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
|
| 14 |
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
|
| 15 |
BILLING_SPECIALIST |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Specialist
Prompt Table:
BI_SPECIALST_VW
|
| 16 |
BILLING_AUTHORITY |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Authority
Prompt Table:
BI_AUTHORITY_VW
|
| 17 |
COLLECTOR |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer to collect overdue payments.
Default Value: CUST_OPTION.COLLECTOR
Prompt Table:
COLLECTOR_TBL
|
| 18 |
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:
BI_TEAM_MBR_VW
Set Control Field: BUSINESS_UNIT
|
| 19 |
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.
Default Value: CUST_OPTION.CR_ANALYST
Prompt Table:
CR_ANALYST_TBL
|
| 20 |
BI_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 21 |
INVOICE_AMT_PRETAX |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Pretax Invoice Amount
|
| 22 |
INVOICE_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount
|
| 23 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 24 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 25 |
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.
|
| 26 |
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:
BI_ENT_TYP_ALVW
Set Control Field: BUSINESS_UNIT_AR
|
| 27 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Default Value: BUS_UNIT_TBL_BI.BUSINESS_UNIT_GL
|
| 28 |
BUSINESS_UNIT_CA |
Character(5) |
VARCHAR2(5) NOT NULL |
Contracts Business Unit
|
| 29 |
CONTRACT_TYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Contract Type
|
| 30 |
BUSINESS_UNIT_OM |
Character(5) |
VARCHAR2(5) NOT NULL |
Order Management Business Unit
Prompt Table:
SP_BU_OM_NONVW
|
| 31 |
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
|
| 32 |
RMA_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
RMA Number
Prompt Table:
BI_RMA_HDR_VW
|
| 33 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
Prompt Table:
BI_SHIP_TO_VW
|
| 34 |
SOLD_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sold To Customer
Prompt Table:
BI_SOLD_TO_VW
|
| 35 |
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
|
| 36 |
SERVICE_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Service Customer ID
Prompt Table:
CUSTOMER
|
| 37 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 38 |
END_DT |
Date(10) |
DATE |
End Date
|
| 39 |
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.
|
| 40 |
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
Default Value: CHK
|
| 41 |
LC_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Treasury Letter of Credit Number Assigned by the System
|
| 42 |
LOC_DOC_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Letter of Credit Document ID
|
| 43 |
ENTRY_EVENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Entry Event
Prompt Table:
EE_AR_CODE1_VW
|
| 44 |
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
Prompt Table:
CUST_AGREE_VW
|
| 45 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
|
| 46 |
SO_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Service Order ID
|
| 47 |
BUSINESS_UNIT_RF |
Character(5) |
VARCHAR2(5) NOT NULL |
Field Services Business Unit
|
| 48 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table:
%EDIT_BU_PC
|
| 49 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
%EDIT_PROJECT
|
| 50 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
%EDIT_ACTIVITY
|
| 51 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
Prompt Table:
PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC
|
| 52 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
Prompt Table:
%EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC
|
| 53 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table:
%EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC
|
| 54 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table:
%EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC
|
| 55 |
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)
|
| 56 |
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)
|
| 57 |
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).
|
| 58 |
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).
|
| 59 |
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).
|
| 60 |
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).
|
| 61 |
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).
|
| 62 |
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).
|
| 63 |
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).
|
| 64 |
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).
|
| 65 |
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).
|
| 66 |
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).
|
| 67 |
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).
|
| 68 |
ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Date Time Added
|
| 69 |
REASON_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Reason Code
Prompt Table:
BI_FSS_RSN_VW
|
| 70 |
REASON_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Reason Type
|
| 71 |
PUBLIC_VOUCHER_NBR |
Number(6,0) |
INTEGER NOT NULL |
Public Voucher Number
|
| 72 |
HOLD_UNTIL_DT |
Date(10) |
DATE |
Hold Until Date
|
| 73 |
BI_APPROVAL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Status
0=Not Required
1=Initial
2=Pending
3=Approved
4=Denied
5=Canceled
Default Value: 0
|
| 74 |
CREATEOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID
|
| 75 |
BI_CREATE_PROC |
Character(2) |
VARCHAR2(2) NOT NULL |
Created By Process
00=Billing Interface
01=Worksheet Online
02=Worksheet Batch
20=Standard Billing
21=Express Billing
22=Consolidated Billing
23=Single Bill Copy
24=Adjust Entire Bill
25=Adjust Line
40=Installment Bill
41=Recurring Bill
42=Copy Bill Group
|