RBQ_QCBC_TMP

(SQL Table)
Index Back

Quick Create BC Flag Temp

Quick Create BC Flag Temporary record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GROUP1 Character(1) VARCHAR2(1) NOT NULL Purchasing Options
2 SOLD_TO_FLG Character(1) VARCHAR2(1) NOT NULL A boolean that flags whether or not the customer is a valid Sold To customer.

Y/N Table Edit

Default Value: N

3 SOLD_TO_FLG_XLAT Character(1) VARCHAR2(1) NOT NULL Sold To Customer
N=No
Y=Yes

Y/N Table Edit

Default Value: N

4 SOLD_TO_CNTCT_XLAT Character(1) VARCHAR2(1) NOT NULL indicate if contact is a sold-to person.
N=Non-primary
P=Primary
5 SOLD_TO_TEXT Character(100) VARCHAR2(100) NOT NULL SOLD_TO_TEXT
6 BILL_TO_FLG Character(1) VARCHAR2(1) NOT NULL A boolean that flags whether or not the customer is a valid Bill To customer.

Y/N Table Edit

Default Value: N

7 BILL_TO_FLG_XLAT Character(1) VARCHAR2(1) NOT NULL Bill To Customer
N=No
Y=Yes

Y/N Table Edit

Default Value: N

8 BILL_TO_CNTCT_XLAT Character(1) VARCHAR2(1) NOT NULL indicate if contact is a bill-to person.
N=Non-primary
P=Primary
9 BILL_TO_TEXT Character(100) VARCHAR2(100) NOT NULL BILL_TO_TEXT
10 SHIP_TO_FLG Character(1) VARCHAR2(1) NOT NULL A flag indicating that the customer or address is a valid Ship To customer or address.

Y/N Table Edit

Default Value: N

11 SHIP_TO_FLG_XLAT Character(1) VARCHAR2(1) NOT NULL Ship To Customer
N=No
Y=Yes

Y/N Table Edit

Default Value: N

12 SHIP_TO_CNTCT_XLAT Character(1) VARCHAR2(1) NOT NULL indicate if contact is a ship-to person.
N=Non-primary
P=Primary
13 SHIP_TO_TEXT Character(100) VARCHAR2(100) NOT NULL SHIP_TO_TEXT