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 |