RBQ_QCBC_TMP(SQL Table) |
Index Back |
|---|---|
Quick Create BC Flag TempQuick 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 |