ORDENT_BOPT_VW(SQL View) |
Index Back |
|---|---|
Bill-to Customer Options |
| SELECT setid , cust_id , effdt , eff_status , pymnt_terms_cd , grace_due_days , grace_disc_days , retention_days , pp_hold , pp_method , ref_qualifier_code , po_required , bill_by_id , bill_cycle_id , bill_type_id , invoice_form_id , dst_id_ar , draft_approval , draft_doc , draft_type , dd_profile_id , dd_group , payment_method , direct_invoicing , customer_po , start_date , end_date , interunit_flg , business_unit_gl , freight_bill_type , immediate_payment , display_prices FROM PS_CUST_OPTION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | 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. |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | 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. |
| 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 | RETENTION_DAYS | Number(3,0) | SMALLINT NOT NULL | Closed Item Retention Days |
| 9 | PP_HOLD | Character(1) | VARCHAR2(1) NOT NULL |
Payment Predictor Hold
Y/N Table Edit |
| 10 | PP_METHOD | Character(15) | VARCHAR2(15) NOT NULL | Payment Predictor Method |
| 11 | REF_QUALIFIER_CODE | Character(2) | VARCHAR2(2) NOT NULL | Reference Qualifier Code |
| 12 | PO_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
Purchase Order Required
Y/N Table Edit |
| 13 | BILL_BY_ID | Character(10) | VARCHAR2(10) NOT NULL | Bill By Identifier |
| 14 | BILL_CYCLE_ID | Character(10) | VARCHAR2(10) NOT NULL | Billing Cycle Identifier |
| 15 | BILL_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL | Bill Type Identifier |
| 16 | INVOICE_FORM_ID | Character(10) | VARCHAR2(10) NOT NULL | Invoice Form |
| 17 | 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. |
| 18 | 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 |
| 19 | 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 |
| 20 | 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). |
| 21 | DD_PROFILE_ID | Character(5) | VARCHAR2(5) NOT NULL | Specifies the Profile ID for a Direct Debit |
| 22 | DD_GROUP | Character(2) | VARCHAR2(2) NOT NULL |
Direct Debit Group
%=All Groups A=Group A B=Group B C=Group C D=Group D |
| 23 | 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 |
| 24 | DIRECT_INVOICING | Character(1) | VARCHAR2(1) NOT NULL |
Direct Invoicing
Y/N Table Edit |
| 25 | CUSTOMER_PO | Character(25) | VARCHAR2(25) NOT NULL | Customer PO |
| 26 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 27 | END_DATE | Date(10) | DATE | End Date |
| 28 | INTERUNIT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
InterUnit
N=No Y=Yes Y/N Table Edit |
| 29 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 30 | FREIGHT_BILL_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Freight Bill Type
OE=Order Entry SH=Shipping |
| 31 | IMMEDIATE_PAYMENT | Character(1) | VARCHAR2(1) NOT NULL |
Immediate Payment Flag
N=No Y=Yes |
| 32 | DISPLAY_PRICES | Character(1) | VARCHAR2(1) NOT NULL | Flag to indicate whether to display prices. |