RSFM_ADDRESS(SQL Table) |
Index Back |
---|---|
Dummy Address Level 1Dummy Address Level 1 record stroing Customer details. |
# | 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 | ADDRESS80 | Character(80) | VARCHAR2(80) NOT NULL | Address |
3 | PRIMARY_IND | Character(1) | VARCHAR2(1) NOT NULL |
Flag that indicates whether or not it is Primary
N=No Y=Yes Y/N Table Edit |
4 | 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 |
5 | 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 |
6 | 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 |
7 | BTN_SELECT | Character(1) | VARCHAR2(1) NOT NULL | Select |
8 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
9 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |