| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
|
| 2 |
CONTACT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
CUSTOMER_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Customer SetID
|
| 5 |
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.
Prompt Table:
CUSTOMER
|
| 6 |
DOCUMENT_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Document Code
ACKN=Order Acknowledgment
ASN=Advance Shipping Notification
BOL=Bill of Lading
CACK=Order Change Acknowledgement
CREN=Buying Agreement Renewal
CSTS=Buying Agreement Status
INCC=Invoice Courtesy Copy
INVC=Invoice
INVN=Invoice Notification
PACK=Packing List
PICK=Picking Plan
PPRC=Product Price List
PRAD=Payment Remittance Advice
QUOT=Quotation
RMA=Return Material Authorization
|
| 7 |
CNTCT_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Contact Sequence Number
|
| 8 |
COMM_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Preferred Communication
A=Email Invoice as Attachment
C=Call
E=Email only
F=Fax
I=XML only
M=Standard Mail
N=Email Notification
P=Email & Print
R=XML & Print
|
| 9 |
NBR_COPIES |
Number(3,0) |
SMALLINT NOT NULL |
Number of Copies
Default Value: 0
|
| 10 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|
| 11 |
DATE_LAST_MAINT |
Date(10) |
DATE |
Date Last Maintained
|