BC_SLDTO_OPT_VW(SQL View) |
Index Back |
|---|---|
Sold-to OptionsThis table stores the processing information and defaults associated with the Sold To Business Contact. The grace days is used to extend a price to a customer after it's expiration date. The flag for product substitutions indicates whether or not this customer accepts substitutes for products ordered. The Part Num flag indicates whether the customer orders using thier part number or the System product ID. |
| SELECT BO_ID , EFFDT , EFF_STATUS , FRT_CHRG_METHOD , GRACE_PRICE_DAYS , LABEL_FORMAT_ID2 , LABEL_FORMAT_ID3 , LOAD_PRICE_RULE , PROD_ID_SRC , PROD_SUBSTITUTE , PRICE_PROGRAM , PRICE_RULE_CD , RESTOCK_FEE_FLAG ,ADJUST_BAPRC_FLG ,VMI_ORDER_CONSOL ,RECEIPT_TRACK_FLG , ROW_LASTMANT_OPRID , ROW_LASTMANT_DTTM FROM PS_BC_SOLDTO_OPT |
| # | 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 | FRT_CHRG_METHOD | Character(2) | VARCHAR2(2) NOT NULL |
Freight Charge Method
01=Order Value 02=Weight 03=Volume 04=Order Quantity |
| 5 | GRACE_PRICE_DAYS | Number(3,0) | SMALLINT NOT NULL | Grace Pricing Discount Days |
| 6 | LABEL_FORMAT_ID2 | Character(30) | VARCHAR2(30) NOT NULL | Carton Label Format ID |
| 7 | LABEL_FORMAT_ID3 | Character(30) | VARCHAR2(30) NOT NULL | Ship Container Label Format ID |
| 8 | LOAD_PRICE_RULE | Character(10) | VARCHAR2(10) NOT NULL | Load Price Rule |
| 9 | PROD_ID_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Product ID Source
C=Customer Product ID S=System Product ID Default Value: S |
| 10 | PROD_SUBSTITUTE | Character(1) | VARCHAR2(1) NOT NULL |
Product Substitute
Y/N Table Edit Default Value: Y |
| 11 | PRICE_PROGRAM | Character(6) | VARCHAR2(6) NOT NULL | Exclusive Pricing ID |
| 12 | PRICE_RULE_CD | Character(10) | VARCHAR2(10) NOT NULL | Price Rule Code |
| 13 | RESTOCK_FEE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Restocking Fee
Y/N Table Edit Default Value: N |
| 14 | ADJUST_BAPRC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Buying Agreement Price Flag
Y/N Table Edit Default Value: N |
| 15 | VMI_ORDER_CONSOL | Character(1) | VARCHAR2(1) NOT NULL |
VMI Order Consolidation
1=Sold To Customer 2=Ship To Customer 3=None |
| 16 | RECEIPT_TRACK_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Receipt Verification
Y/N Table Edit Default Value: N |
| 17 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 18 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |