| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BO_ID |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Business Object ID
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %Date
|
| 3 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 4 |
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:
PAY_TRMS_VW
|
| 5 |
PYMNT_TERMS_AMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Terms Basis Amount
1=User Amount 1
2=User Amount 2
G=Gross Voucher Amount
I=Item Amount
V=VAT Discountable Amount
|
| 6 |
GRACE_DUE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Due Grace Days
|
| 7 |
GRACE_DISC_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Discount Grace Days
|
| 8 |
IMMEDIATE_PAYMENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to determine if immediate payment is required.
Y/N Table Edit
Default Value: N
|
| 9 |
RETENTION_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Closed Item Retention Days
|
| 10 |
PP_HOLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Predictor Hold
Y/N Table Edit
Default Value: N
|
| 11 |
PP_METHOD |
Character(15) |
VARCHAR2(15) NOT NULL |
Payment Predictor Method
|
| 12 |
REF_QUALIFIER_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
Reference Qualifier Code
|
| 13 |
PARTIAL_PY_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Payment Switch
Y/N Table Edit
Default Value: N
|
| 14 |
PO_REQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
PO Required
Y/N Table Edit
Default Value: N
|
| 15 |
BILL_BY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill By Identifier, used in Contracts Integration message
|
| 16 |
FREIGHT_BILL_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Freight Bill Type
OE=Bill Order Entry Est. Freight
SH=Bill Shipping Est. Freight
Default Value: SH
|
| 17 |
BILL_CYCLE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Cycle Identifier, field used in Contracts Integration Message
|
| 18 |
BILL_INQUIRY_PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Bill Inquiry Phone , used in Contracts Integration Message
|
| 19 |
BILL_TYPE_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
This field stores the Bill Type Identifier.
|
| 20 |
BILLING_SPECIALIST |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Specialist, used in Contracts Integration message
|
| 21 |
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_VW
|
| 22 |
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_VW
|
| 23 |
INVOICE_FORM_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Invoice Form
|
| 24 |
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.
|
| 25 |
DRAFT_APPROVAL |
Character(1) |
VARCHAR2(1) NOT NULL |
"Indicates whether or not a draft is pre-approved for payment by a bill-to customer. If the draft is pre-approved then it can be submitted to the customer's bank without the customer's sign-off. Otherwise the draft must be reviewed and approved by the customer before the enterprise can submit it to the bank for payment. This field is used only if the preferred payment method is ""Draft""."
P=Preapproved
R=Approval Required
|
| 26 |
DRAFT_DOC |
Character(1) |
VARCHAR2(1) NOT NULL |
"A flag that indicates whether or not (C or N) a draft document should be created for a Receivables item when the payment method is ""draft"". If the value is N then the system prints only a draft statement. If the value is C then the system creates a draft document. "
C=Create Document
N=Do Not Create Document
|
| 27 |
DRAFT_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
A flag that indicates whether a draft is initiated by the vendor (1) or by the customer (2).
|
| 28 |
DD_PROFILE_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the Profile ID for a Direct Debit
|
| 29 |
DD_GROUP |
Character(2) |
VARCHAR2(2) NOT NULL |
Direct Debit Group
%=All Direct Debit Groups
A=Group A
B=Group B
C=Group C
D=Group D
|
| 30 |
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.
CC=Credit Card
CHK=Check
DD=Direct Debit
DR=Draft
EFT=Electronic Fund Transfer
INV=Invoice
Default Value: CHK
|
| 31 |
DIRECT_INVOICING |
Character(1) |
VARCHAR2(1) NOT NULL |
Direct Invoicing
Y/N Table Edit
Default Value: Y
|
| 32 |
CUSTOMER_PO |
Character(25) |
VARCHAR2(25) NOT NULL |
Customer PO
|
| 33 |
START_DATE |
Date(10) |
DATE |
Start Date for Gen Standing PO
|
| 34 |
END_DATE |
Date(10) |
DATE |
End date field to store an end date.
|
| 35 |
MICR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
MICR ID
|
| 36 |
CONSOL_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Consolidation Customer SetID
|
| 37 |
CONSOL_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Consolidation Customer ID
|
| 38 |
CONSOL_KEY |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice Consolidation Key
|
| 39 |
INTERUNIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
InterUnit
Y/N Table Edit
Default Value: N
|
| 40 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
This field stores the General Ledger Business Unit. Used for the Integration with Contracts/Billing from CRM.
|
| 41 |
DM_SPECIALIST |
Character(8) |
VARCHAR2(8) NOT NULL |
Deduction Specialist
|
| 42 |
DM_WRITE_OFF_AMT |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Deduction Write-off Amount
|
| 43 |
DM_WRITE_OFF_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Days Till Write-off
|
| 44 |
DM_WRITE_OFF_PCT |
Number(3,0) |
SMALLINT NOT NULL |
Deduction Write-off Percent
|
| 45 |
HOL_PROC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Holiday Processing Option
A=Due After Holiday
B=Due Before Holiday
N=Not Applicable
Default Value: N
|
| 46 |
HOL_PROC_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Days before/after Holiday
|
| 47 |
HOL_PROC_OVERFL |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow due date in next month
Y/N Table Edit
Default Value: Y
|
| 48 |
REBATE_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Rebate Method
C=Pay by Check
M=Issue Credit Memo
N=No Rebate Method
Default Value: N
|
| 49 |
BI_PROMPT_CURR |
Character(1) |
VARCHAR2(1) NOT NULL |
Prompt field for billing currency, used for order capture inherited purchasing options.
Y/N Table Edit
Default Value: N
|
| 50 |
DEPOSIT_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Deposit Percentage
|
| 51 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 52 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 53 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 54 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 55 |
SYNCID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
|
| 56 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|