| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 CAPTURE_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Field use to store the capture ID in order capture.
|
| 2 |
UID20 |
Character(20) |
VARCHAR2(20) NOT NULL |
This field is for UID of 20 characters long.
|
| 3 |
UID20F_SOLD |
Character(20) |
VARCHAR2(20) NOT NULL |
Foreign UID
|
| 4 |
UID20F_SOLDC |
Character(20) |
VARCHAR2(20) NOT NULL |
Foreign UID
|
| 5 |
SOLD_TO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A boolean that flags whether or not the customer is a valid Sold To customer.
|
| 6 |
RO_BILL_TO_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Field use to determinate if the products are shipped to the partner or to the end customer.
C=Customer
P=Partner
Default Value: C
|
| 7 |
CUSTOMER_PO |
Character(25) |
VARCHAR2(25) NOT NULL |
Customer PO
|
| 8 |
CONFIRM_PO_RECVD |
Character(1) |
VARCHAR2(1) NOT NULL |
Confirming PO Received
Y/N Table Edit
|
| 9 |
RESELL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates that the products on an order will are for resell.
Y/N Table Edit
|
| 10 |
SCHEDULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Schedule for integration with Contracts.
Prompt Table:
RO_SCHEDULE_VW
|
| 11 |
UID20F_CCOT |
Character(20) |
VARCHAR2(20) NOT NULL |
Credit Card
|
| 12 |
BILL_RECIPIENT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used in bulk ordering mode to determinate if the bill will be sent to the recipient's billing address or to the address from the master order.
B=Use Address on Bulk Order
R=Use Recipient Customer Address
|
| 13 |
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
|
| 14 |
UID20F |
Character(20) |
VARCHAR2(20) NOT NULL |
Foreign UID...................................................................
|
| 15 |
UID20F_BILL |
Character(20) |
VARCHAR2(20) NOT NULL |
Foreign UID
|
| 16 |
UID20F_BILLC |
Character(20) |
VARCHAR2(20) NOT NULL |
Foreign UID
|
| 17 |
UID20F_R_BILL |
Character(20) |
VARCHAR2(20) NOT NULL |
Field used to store UID of Recurring billing owner
|
| 18 |
UID20F_R_BILLC |
Character(20) |
VARCHAR2(20) NOT NULL |
Field used to store UID of Recurring billing owner contact
|
| 19 |
UID20F_CCRC |
Character(20) |
VARCHAR2(20) NOT NULL |
Foreign UID
|
| 20 |
UID20F_PARTNER |
Character(20) |
VARCHAR2(20) NOT NULL |
This field is for UID of 20 characters long.
|
| 21 |
UID20F_PARTNERC |
Character(20) |
VARCHAR2(20) NOT NULL |
This field is for UID of 20 characters long.
|
| 22 |
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
|
| 23 |
RBTNEWACCT |
Character(1) |
VARCHAR2(1) NOT NULL |
New Account
E=Existing Account
N=New Account
R=Reuse New Account
|
| 24 |
RBTACCTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Unique service account indentifier
Prompt Table:
RBT_CUSREPAC_VW
|
| 25 |
RBTACCTTYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Determines the type of Billing Account.
IND=Individual Account
NSUB=Parent Account
PRE=Prepaid Account
SPNR=Sponsored Account
SPON=Sponsoring Account
SUB=Subordinate Account
|
| 26 |
RBTPARENTACCTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Parent Account Id
Prompt Table:
RBT_PARACCT_VW
|
| 27 |
RBTSPONSOREDACCTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sponsored Account Id
Prompt Table:
RBT_SPINGACT_VW
|
| 28 |
RBTRECPAYMETHOD |
Character(4) |
VARCHAR2(4) NOT NULL |
Payment Method
CC=New Credit Card
DO=Same as Non-Recurring Charges
ECC=Credit Card on File
INV=Invoice
|
| 29 |
RBTACCTID_TO |
Character(15) |
VARCHAR2(15) NOT NULL |
Unique service account indentifier
|
| 30 |
RBTACCTID_NONR |
Character(15) |
VARCHAR2(15) NOT NULL |
Field used for storing nonrecurring Billing Account ID
Prompt Table:
RBT_CUSREPAC_VW
|
| 31 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 32 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 33 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 34 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 35 |
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.
|
| 36 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|