IM Fdg Doc Ett

Unique ID for the specific run of FDG Extract Batch.

Unique Identifier of the Entity record.

Unique Identifier of the document.

Entity Doc type. Possible values are ''SD'' for sender, ''RC'' for receiver, ''CR'' for Carrier.

RMS Entity type. Possible values are ''WH'' (Warehouse) ''ST'' (Store) ''SUPP'' (Supplier) or ''PTRN'' (Partner)

Partner Type. Set only when ETT_TYPE is ''PTRN''

RMS Identifier of the Entity. Oracle Retail target column ETT_CODE on IM_FDG_DOC_ETT.

Name of the Entity. Oracle Retail target column NAME on IM_FDG_DOC_ETT.

Legal Name of the Entity. Oracle Retail target column LEGAL_NAME on IM_FDG_DOC_ETT.

The name of the street, road, avenue, way, etc. to which the number of the building is attached.

An additional street name used to further clarify the address.

Additional address information that can be used to give further details.

The name of the city associated with the addess.

Jurisdiction Code for the country-stae relationship.

Zip code of the addresst. Oracle Retail target column POSTAL_CODE on IM_FDG_DOC_ETT.

Country where the address exists.

State where the address exists.

Contains the name of the contact person for this address.

Contains the phone number of the contact person for this address.

Contains the email address of the contact person for this address.

Oracle Retail target column CARRIER_VEHICLE_RN on IM_FDG_DOC_ETT.

Oracle Retail target column CARRIER_VEHICLE_STATE on IM_FDG_DOC_ETT.

Oracle Retail target column CARRIER_DRIVER_NAME on IM_FDG_DOC_ETT.

Oracle Retail target column CARRIER_DRIVER_LN on IM_FDG_DOC_ETT.

User that created this record.

Timestamp of Record creation. Oracle Retail target column CREATE_DATETIME on IM_FDG_DOC_ETT.

User that last updated this record.

Timestamp of Last updation. Oracle Retail target column LAST_UPDATE_DATETIME on IM_FDG_DOC_ETT.