RSFM_ADDRESS

(SQL Table)
Index Back

Dummy Address Level 1

Dummy 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