Updated: January 11, 2022 9:16am

RPS Database Tables

Prism 2.0 Database Tables PDF

Disclaimer: This topic is currently under construction. Download the PDF linked above for the full list of tables.

AC_PUBLISHER

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE   Date/time row was created. Default = sysdate
MODFIED_BY NVARCHAR2(30) Yes Employee ID of last employee who modified the record using the application UI.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time row was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row.
POST_DATE TIMESTAMP(0) WITH TIME ZONE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME.
ROW_VERSION NUMBER(10) No Optimistic locking value. Default = 1
TENANT_SID NUMBER(19) Yes Reference to tenant description.
ACTIVE NUMBER(1) No 0 = inactive; 1 = active.
Default = 1
ADDRESS NVARCHAR2(100) No IP Address or URL, with optional port, for publisher's host machine.
USER_NAME NVARCHAR2(30) Yes Username for connecting to the publisher.
PASSWORD NVARCHAR2(30) Yes Encrypted password for connecting to the publisher.
INSTALLATION_ID NUMBER(5) Yes Copy of publisher's SUBSIDIARY.SBS_NO
INSTALLATION_NAME NVARCHAR2(15) Yes Copy of publisher's SUBSIDIARY.SBS_NAME.
PORT NUMBER(5) Yes Port through which the publisher can be accessed.
INSTALLATION_TYPE NUMBER(1) No Type of system the publisher resides in: 0=Prism, 1=RetailPro9

AC_SUBSCRIPTION

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time row was created. Default = sysdate
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of last employee who modified the record using the application UI.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time row was last modified
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row.
POST_DATE TIMESTAMP(0) WITH TIME ZONE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value
TENANT_SID NUMBER(19) Yes Indicates application used to create row.
SUBSCRIPTION_GROUP_SID NUMBER(19) No Reference to a subscription group.
SUBSCRIPTION_NAME NVARCHAR2(40) No Name given to this subscription. This will be the name on the subscription at the publisher.
EVENT_TYPE NUMBER(5) No Bitmask indicating which data events to monitor. Bit 1 = create, bit 2 = update, bit 3 = delete.
ATTRIBUTES_AFFECTED NVARCHAR2(1024) Yes If eventtype includes "create" or "update," this is th elist of attributes affected by the change. This functions as a type of filter on the event - if this is specified one of the attributes in the list must have been affected in order to match. Default = 7
RESOURCE_NAME NVARCHAR2(50) No Name of resource. By convention, same as the name of the Business Object entity.
DELETED NUMBER(1) No 0=Not deleted, 1=Deleted and pending notification to the publishers. Default=0
FILTERS CLOB Yes String list of filter expressions, each consisting of attribute, operator, and value.
LAST_PROCESS_DATE TIMESTAMP(0) WITH TIME ZONE Yes The last time that data was processed into the local database.
LAST_MESSAGE_DATE TIMESTAMP(0) WITH TIME ZONE Yes Indicates the last date/time of a notification.
LAST_MESSAGE_TYPE NUMBER(5) Yes Indicates the status of the subscription on the publisher.
LAST_PROCESS_STATUS NUMBER(5) Yes Comment status on processed data. 0=Success, 1=Success with Errors, 2=Failed
LAST_MESSATGE_STATUS NUMBER(5) Yes Status on processed data. 0=Success, 1=Failure

AC_SUBSCRIPTION_GROUP

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time row was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of last employee who modified the record using the application UI.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time row was last modified
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row.
POST_DATE TIMESTAMP(0) WITH TIME ZONE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant subscription.
ACTIVE NUMBER(1) No 0=inactive, 1=active. Default=1
SUBSCRIPTION_GROUP_ID NVARCHAR2(38) No Unique identifying, randomly generated guid value for this subscription group.
SUBSCRIPTION_GROUP_NAME NVARCHAR2(40) No Name given to this subscription group.
TEMPLATE NUMBER(1) No 0=regular subscription, 1=template that a new subscription can be initialized from
START_DATETIME TIMESTAMP(0) WITH TIME ZONE No Datetime when to start generating notifications fo this subscription group. Default=sysdate
SCHEDULE_TYPE NUMBER(1) No Schedule type (upon receipt, daily, weekly, monthly, hourly, one-time) Default=0
RECURRENCE NUMBER(2) No Repetition frequency
TIME_POINTS NVARCHAR2(60) Yes When to process notifications. Actual contents depends on schedule type.
LAST_PROCESS_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date and time of last attempt to process a notification.
LAST_PROCESS_STATUS NVARCHAR2(200) Yes Result of last attempt to process a notification

AC_SUBSCRIPTION_PUBLISHER

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time row was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of last employee who modified the record using the application UI.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time row was last modified
COINTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row.
POST_DATE TIMESTAMP(0) WITH TIME ZONE No Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) Yes Optimistic locking value. Default=1
TENANT_SID NUMBER(19) No Reference to tenant description.
SUBSCRIPTION_SID NUMBER(19) Yes Reference to subscription.
PUBLISHER_SID NUMBER(19) No Reference to a publisher.
TRANSMIT_STATUS NUMBER(1) No 0=pending, 1-transmitted, 2=error. Default=0
LAST_FAILED_ATTEMPT_REASON NVARCHAR2(200) Yes Reason the last transmission attempt failed, including error codes.
LAST_FAILED_ATTEMPT_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date and time of last attempted (but failed) transmission.

ADDED_TENDER

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value
CREATED_BY NVARCHAR2(30) Yes Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time row was created
MODIFIED_BY NVARCHAR2(30) No Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time row was last modified.
CONTROLLER_SID NUMBER(10) Yes Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. applications
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant description.
TENDER_SID NUMBER(19) Yes Reference to tender.
TENDER_TYPE NUMBER(5) Yes Type of tender.
DOC_NO NUMBER(10) Yes Document identifying number.
AMOUNT NUMBER(16,4) Yes Amount of this tender.
TENDER_DATE TIMESTAMP(0) WITH TIME ZONE Yes Datetime on tender receipt.
CUSTOMER_NAME NVARCHAR2(60) Yes Name of the customer.
CASHIER_FULL_NAME NVARCHAR2(60)   Name of the casheir for the tender.
NOTES NVARCHAR2(120) YesYes Notes for the added tender.
EFT_INVC_NO NUMBER(10) Yes EFT Invoice identifying number.
OPEN_DRAWER_EVENT_SID NUMBER(19) Yes Ties the found tender to the Open event when it was found
CARD_TYPE_NAME NVARCHAR2(30) Yes .Contains the name of the credit card that is being added.

ADDRESS_TYPE

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATD_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time row was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time row was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row.
POST_DATE TIMESTAMP(0) WITH TIME ZONE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant description.
TYPE_NAME NVARCHAR2(30) No Address type name (e.g., Home2, Work1)
SBS_SID NUMBER(19) No The subsidiary to which this address type is associated.
ACTIVE NUMBER(1) Yes 0=inactive, 1=active. Default=1

ADJUSTMENT

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value
CREATED_BY NVARCHAR2(3) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time row was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time row was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row.
POST_DATE TIMESTAMP(0) WITH TIME ZONE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME.
ROW_VERSION NUMBER(10)   Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant description.
SBS_SID NUMBER(19)   The subsidiary to which this adjustment is associated.
STORE_SID NUMBER(19) Yes The store to which this adjustment is associated.
ADJ_NO NUMBER(10) Yes Adjustment memo number.
ADJ_TYPE NUMBER(5) Yes 0=Qty, 1=Price, 2=Cost
CREATING_DOC_NO NUMBER(10) Yes If the doc was created as a result of another doc, that doc no is listed.
CREATING_DOC_TYPE NUMBER(5) Yes Represents the SID of the document for which the adjustment was created automatically. 0=None, 1=PI, 2=Cost Override, 3=Markdown, 4=Cleanup, 5=Planned Pricing, 6=Planned Markdown, 7=Inventory, 8=Manual, 9=Reversing, 10=Cost Leave, 11=Audit, 12=Corporate, 13=Kit, 14=Unverified Slip,
ORIG_STORE_SID NUMBER(19) Yes Unique ID for the original store where the adjustment was created.
ORIG_STATION NCHAR(1) Yes Identifies the station where the adjustment was created.
CLERK_SID NUMBER(19) Yes Unique ID for the clerk on the document.
PRICE_LVL_SID NUMBER(19) Yes Unique ID for the price level on the document.
WORKSTATION_SID NUMBER(19) Yes Identifies the workstation that created the document.
STATUS NUMBER(10) Yes 0=None, 1=Changed, 2=Cancelled, 3=Normal, 4=Completion
ADJ_REASON_SID NUMBER(19) Yes Identifies the reason used for the adjustment.
TAX_AREA_SID NUMBER(19) Yes Override tax area should be 0.
USE_VAT NUMBER(1) Yes Use VAT? 0 = no; 1 = yes. Default = 0
AUDITED NUMBER(1) Yes Audited? 0 = no; 1 = yes. Default = 0
CMS NUMBER(1) Yes CMS? 0 = no; 1 = yes. Default = 0
VERIFIED NUMBER(1) Yes Verified? 0 = no; 1 = yes. Default = 0
WS_SEQ_NO NUMBER(10) Yes Workstation sequence number.
HELD NUMBER(1) Yes Held? 0 = no; 1 = yes. Default = 0
CONTROLLER NUMBER(5) Yes Controller number.
ORIG_CONTROLLER NUMBER(5) Yes Controller at time of document creation.
CREATEDBY_SID NUMBER(19) Yes Identifies the employee who created the document.
MODIFIEDBY_SID NUMBER(19) Yes Identifies the employee who last modified the document.
DOC_REF_NO NUMBER(10) Yes Used to externally identify a document prior to that document being updated or saved/held
TAX_AREA2_SID NUMBER(19) Yes In a multi-tax environment, identifies the tax area used for the second tax.
SUBLOCATION_SID NUMBER(19) Yes Identifies the sublocation.
DOC_REASON_SID NUMBER(19) Yes Identifies the document reason used on the memo.
SEASON_SID NUMBER(19) Yes SID of seasons.
SUBLOC_MOVE_TYPE NUMBER(1) Yes Used to identify adjustments related to sublocation quantities. 0=None, 1=MovementOnly, 2=Movement/Adjustment
NOTE NVARCHAR2(255) Yes Note text.
GL_FLAG NUMBER(1) Yes Sent to General Ledger? 0=No, 1= Yes.
COPIED_FLAG NUMBER(1) Yes Copied? 0=No, 1=Yes.
REVERSED_FLAG NUMBER(1) Yes Reversed? 0=No, 1=Yes.
TOT_ORIG_QTY NUMBER(10,3) Yes Total original quantity.
TOT_ADJ_QTY NUMBER(10,3) Yes Total adjusted quantity.
TOT_ORIG_EXT_COST NUMBER(16,4) Yes Total original extended cost.
TOT_ORIG_EXT_PRICE NUMBER(16,4) Yes Total original extended price.
TOT_ADJ_EXT_PRICE NUMBER(16,4) Yes Total adjusted extended price.
TOT_ADJ_EXT_COST NUMBER(16,4) Yes Total adjusted extended cost.
CREATING_DOC_SID NUMBER(19) Yes The SID of the document for which the adjustment was created automatically (e.g., reverse).
TOT_ORIG_EXT_PRICE_WO_TAX NUMBER(16,4) Yes Total extended price without tax for original value.
TOT_ADJ_EXT_PRICE_WO_TAX NUMBER(16,4) Yes Total extended price without tax for adjusted value.
TOT_ORIG_EXT_PRICE_W_TAX NUMBER(16,4) Yes Total extended price with tax for original value.
TOT_ADJ_EXT_PRICE_W_TAX NUMBER(16,4) Yes Total extended price with tax for adjusted value.
EXTERNAL_TRANSFER_STATUS NVARCHAR2(255) Yes Only for external apps usage for tracking data transfer status.
AL_EXTRACT_DATE DATE Yes Accounting Link extract date.
AL_POST_DATE DATE Yes Accounting Link post date.

ADJ_COMMENT

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time row was created. Default=sysdate
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time row was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant description.
ADJ_SID NUMBER(19) No Unique identifier for the adjustment.
COMMENT_NO NUMBER(5) No Comment number in the list.
COMMENTS NVARCHAR2(60) Yes Comment text

ADJ_GIFT_CARD

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of last employee who modified the record using the application UI.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTOLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default = 1.
TENANT_SID NUMBER(19) Yes Reference to tenant description.
ADJ_ITEM_SID NUMBER(19) No Unique identifier of the adjusted item referenced in the ADJ_ITEM table.
GIFT_CARD_NO NVARCHAR2(32) No Gift card number for older non-central gift card numbers.
ORIG_QTY NUMBER(10,3) Yes The original quantity of the gift card item (older non-central gift card numbers)
ADJ_QTY NUMBER(10,3) Yes The adjusted quantity made to the gift card (older non-central gift card numbers) via quantity adjustment memos.

ADJ_ITEM

Column Name Type Nullable? Notes
SID NUMBER(19)   Unique identifying value.
CREATED_BY NVARCHAR2(30)   Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE   Date/time the record was created.
MODIFIED_BY NVARCHAR2(20) Yes Employee ID of last employee who modified the record using the application UI.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19)   Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20)   Indicates application used to create row.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10)   Optimistic locking value. Default = 1.
TENANT_SID NUMBER(19) Yes Reference to tenant description.
ADJ_SID NUMBER(19)   Unique identifier for the adjustment.
ITEM_POS     Item position in the item list.
ITEM_SID NUMBER(19)   Unique identifier for the item.
ORIG_VALUE NUMBER(16,4) Yes Original value (before adjustment).
ADJ_VALUE NUMBER(16,4) Yes Adjusted value.
COST NUMBER(16,4) Yes Item cost.
PRICE NUMBER(16,4) Yes Item price.
TAX_CODE_SID NUMBER(19) Yes Unique identifier for the tax code.
TAX_PERC NUMBER(16,4)   Tax percentage.
TAX_AREA2_SID NUMBER(19) Yes In a multi-tax environment, a unique identifier for the second tax area.
TAX_PERC2 NUMBER(16,4) Yes In a multi-tax environment, the second tax's percentage.
SCAN_UPC NUMBER(18) Yes Scanned UPC value.
SERIAL_NO NVARCHAR2(50) Yes This column is obsolete and has been replaced by ADJ_SERIAL.
UDF_VALUE1 NVARCHAR2(50) Yes Used to record a UDF value that existed at the time the document was created. This field does not necessarily correspond to Inventory UDF 1. Extended with more characters to hold proper translation when necessary.
UDF_VALUE2 NVARCHAR2(50) Yes Used to record a UDF value that existed at the time the document was created. This field does not necessarily correspond to Inventory UDF 2. Extended with more characters to hold proper translation when necessary.
UDF_VALUE3 NVARCHAR2(50) Yes Used to record a UDF value that existed at the time the document was created. This field does not necessarily correspond to Inventory UDF 3. Extended with more characters to hold proper translation when necessary.
UDF_VALUE4 NVARCHAR2(50) Yes Used to record a UDF value that existed at the time the document was created. This field does not necessarily correspond to Inventory UDF 4. Extended with more characters to hold proper translation when necessary.
ORIG_COST NUMBER(16,4) Yes Corresponds to base item cost (from V8).
ITEM_NOTE1 NVARCHAR2(350) Yes Item Note 1
ITEM_NOTE2 NVARCHAR2(350) Yes Item Note 2
ITEM_NOTE3 NVARCHAR2(350) Yes Item Note 3
ITEM_NOTE4 NVARCHAR2(350) Yes Item Note 4
ITEM_NOTE5 NVARCHAR2(350) Yes Item Note 5
ITEM_NOTE6 NVARCHAR2(350) Yes Item Note 6
ITEM_NOTE7 NVARCHAR2(350) Yes Item Note 7
ITEM_NOTE8 NVARCHAR2(350) Yes Item Note 8.
ITEM_NOTE9 NVARCHAR2(350) Yes Item Note 9.
ITEM_NOTE10 NVARCHAR2(350) Yes Item Note 10.
ALT_UPC NUMBER(18) Yes Alternate vendor information.
ALT_APU NVARCHAR2(20) Yes Alternate vendor information.
ALT_COST NUMBER(16,4) Yes Alternate vendor information.
ALT_VEND_CODE NVARCHAR2(6) Yes Alternate vendor information.
SUBLOC_MOVE_TYPE NUMBER(1) Yes Used to identify adjustments related to sublocations. 0=None, 1=Movement Only, 2=Movement/Adjustment. Default=0
CMP_QTY NUMBER(10,3) Yes Company on-hand quantity.
ORIG_TAX NUMBER(17,5) Yes Tax amount calculated for original value.
ADJ_TAX NUMBER(17,5) Yes Tax amount calculated for adjusted value.

ADJ_LOT_QTY

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
ADJ_ITEM_SID NUMBER(19) No Unique identifier for the item.
LOT_NUMBER NVARCHAR2(25) No Lot number.
ORIG_QTY NUMBER(10,3) Yes Original quantity assigned to the lot number.
ADJ_QTY NUMBER(10,3) Yes New lot number quantity. This value will be updated in the LOT_QTY table. It is retained here for history purposes only.
SUBLOC_ID NUMBER(10) No Identifies the sublocation.

ADJ_QTY

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATE_TIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to the tenant description.
ADJ_ITEM_SID NUMBER(19) No Unique identifier for the item being adjusted.
STORE_SID NUMBER(19) No Reference to the store to which the adjustment is associated.
QTY NUMBER(10,3) Yes Item quantity.
SBS_SID NUMBER(19) Yes Reference to the subsidiary to which the adjustment is associated.

ADJ_SERIAL

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
ADJ_ITEM_SID NUMBER(19) No Unique identifier for the item.
SERIAL_NO NVARCHAR2(25) No Serial number.
ORIG_QTY NUMBER(10,3) Yes Original quantity assigned to the serial number.
ADJ_QTY NUMBER(10,3) Yes New serial number quantity. This value will be updated in the SERIAL_QTY table. It is retained here for history purposes only.
NOTES NVARCHAR2(255) Yes 0=None, 1=Insert, 2=Remove
SUBLOC_ID NUMBER(10) No Identifies the sublocation.

ADJ_SUBLOCATION

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
ADJ_ITEM_SID NUMBER(19) No Unique identifier for the item.
SUBLOC_ID NUMBER(10) No Identifies the sublocation. Default=1.
ORIG_QTY NUMBER(10,3) Yes Original quantity assigned to the sublocation.
ADJ_QTY NUMBER(10,3) Yes New sublocation quantity. This value will be updated in the SUBLOCATION_QTY table. It is retained here for history purposes only.

ALLOCATION_PATTERN

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
SBS_SID NUMBER(19) No Reference to subsidiary to which the pattern is assigned.
PATTERN_ID NUMBER(10) No Sequential pattern number.
PATTERN_NAME NVARCHAR2(20) No Unique name for the pattern.

ALLOCATION_PATTERN_QTY

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
PATTERN_SID NUMBER(10) No Reference to ALLOCATION_PATTERN table.
STORE_SID NUMBER(19) No Reference to store to which the pattern is assigned.
ORDERED_QTY NUMBER(10,3) Yes Quantity ordered or transferred to each store.

APPLICATION

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

APPLICATION_AREA

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

APPLICATION_PERMISSION

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

AUDIT_LOG

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

AUDIT_OVERRIDE_LOG

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

AUTO_CONFIG

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

AUTO_CONFIG_PARAM

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant description.
       
       
       
       
       
       

AUTO_CONFIG_STAGED_PARAM

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

AUTO_MM_FORMULA

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

AUTO_MM_FORMULA_DETAIL

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

BIOMETRICS

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

BUSINESS_UNIT

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

CALENDAR

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
CAL_TYPE NUMBER(5) No 0=Store Schedule, 1=Retail Calendar. Default=0
CAL_NAME NVARCHAR2(255) No Calendar name.
FREQUENCY NUMBER(5) No second=1, minute=2, hour=3, day=4, week=5, month=6, quarter=7, year=8, 10-day=10, semi-monthly=16, semi-annual=18
ANCHOR_DATE DATE No Anchor date.
BEGIN_DATE DATE Yes Begin date of the calendar.
END_DATE DATE Yes End date of the calendar.
PLAN_YEAR NUMBER(4) Yes Year.
CAL_ID NUMBER(10) No Helps in identifying a calendar entry and any modification.

CENTRAL_CREDIT

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
CUST_SID NUMBER(19) No Customer SID
CUSTOMER_NAME NVARCHAR2(80) Yes Customer Name
CONTROLLER NUMBER(5) Yes Controller Number.
SBS_NO NUMBER(5) No Subsidiary number.
STORE_NO NUMBER(5) No Store number.
BALANCE NUMBER(16,4) Yes Customer credit balance.
HOLD_TXN NUMBER(16,4) Yes  
CURRENCY_CODE NVARCHAR2(10) Yes Currency Code.
       

CENTRALCREDIT_HOLDTXN

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
CENTRAL_SID NUMBER(19) Yes Central Customer SID
CUST_SID NUMBER(19) Yes Customer SID.
CONTROLLER NUMBER(19) Yes Controller number.
SBS_NO NUMBER(5) Yes Subsidiary number.
STORE_NO NUMBER(5) Yes Store number.
DOCUMENT_SID NUMBER(19) Yes Document SID.
DOCUMENT_NO NUMBER(10) Yes Document number.
DOCUMENT_TOTAL NUMBER(16,4) Yes Document total.
TXN_TYPE NUMBER(1) Yes Transaction  type. 0=Add, 1=Redeem
TXN_REASON NVARCHAR2(30) Yes Transaction reason.
AMOUNT NUMBER(16,4) Yes Transaction amount.
STATUS NUMBER(1) Yes Status
CURRENCY_CODE NVARCHAR2(10) Yes Currency code.

CENTRAL_CREDIT_TXN

Column Name Type Nullable? Notes
       
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
CENTRAL_SID NUMBER(19) Yes Central Customer SID
CUST_SID NUMBER(19) Yes Customer SID.
CONTROLLER NUMBER(19) Yes Controller number.
SBS_NO NUMBER(5) Yes Subsidiary number.
STORE_NO NUMBER(5) Yes Store number.
DOCUMENT_SID NUMBER(19) Yes Document SID.
DOCUMENT_NO NUMBER(10) Yes Document number.
DOCUMENT_TOTAL NUMBER(16,4) Yes Document total.
TXN_TYPE NUMBER(1) Yes Transaction  type. 0=Add, 1=Redeem
TXN_REASON NVARCHAR2(30) Yes Transaction reason.
AMOUNT NUMBER(16,4) Yes Transaction amount.
STATUS NUMBER(1) Yes Status
CURRENCY_CODE NVARCHAR2(10) Yes Currency code.

CENTRAL_GIFT_CARD

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
SBS_NO NUMER(5) Yes Subsidiary number.
STORE_NO NUMBER(5) Yes Store number.
GIFT_CARD_NO NVARCHAR2(32) No Gift Card number.
GIFT_CARD_STATE NUMBER(1) Yes Gift card state
BALANCE NUMBER(16,4) Yes Gift card balance.
CURRENCY_CODE NVARCHAR2(10) Yes Currency code.
LAST_ACTIVITY_DATE DATE Yes Last date for activity.
ORIGINAL_BALANCE NUMBER(16,4) Yes Original balance.
EXP_DATE DATE Yes Gift card expiration date.
MAX_AMT NUMBER(16,4) Yes Maximum limit amount.

CENTRAL_GIFT_CARD_RB

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
SBS_NO NUMER(5) Yes Subsidiary number.
STORE_NO NUMBER(5) Yes Store number.
GIFT_CARD_NO NVARCHAR2(32) No Gift Card number.
GIFT_CARD_STATE NUMBER(1) Yes Gift card state
BALANCE NUMBER(16,4) Yes Gift card balance.
CURRENCY_CODE NVARCHAR2(10) Yes Currency code.
LAST_ACTIVITY_DATE DATE Yes Last date for activity.
ORIGINAL_BALANCE NUMBER(16,4) Yes Original balance.
EXP_DATE DATE Yes Gift card expiration date.
MAX_AMT NUMBER(16,4) Yes Maximum limit amount.

CENTRAL_GIFT_CARD_TXN

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
GIFT_CARD_SID NUMBER(19) No Gift Card SID.
SBS_NO NUMBER(5) Yes Subsidiary number
STORE_NO NUMBER(5) Yes Store number
GIFT_CARD_NO NVARCHAR2(32) Yes Gift card number.
START_BALANCE NUMBER(16,4) Yes Starting balance for the card for the transaction.
AMOUNT NUMBER(16,4) Yes Transaction amount.
END_BALANCE NUMBER(16,4) Yes Ending balance for the card for the transaction.
TXN_TYPE NUMBER(1) Yes Transaction type. 0=Add, 1=Redeem.
DOCUMENT_SID NUMBER(19) Yes Document SID
DOCUMENT_NO NUMBER(10) Yes Document number.
DOCUMENT_TOTAL NUMBER(16,4) Yes Document total.
EXP_DATE DATE Yes Gift card expiration date.
MAX_AMT NUMBER(16,4) Yes Max gift card limit amount.
CURRENCY_CODE NVARCHAR2(10) Yes Currency code.
CUSTOMER_NAME NVARCHAR2(50) Yes Customer name.
EMPLOYEE_NAME NVARCHAR2(50) Yes Employee name.

CENTRAL_GIFT_CARD_TXN_RB

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
GIFT_CARD_SID NUMBER(19) No Gift Card SID.
SBS_NO NUMBER(5) Yes Subsidiary number
STORE_NO NUMBER(5) Yes Store number
GIFT_CARD_NO NVARCHAR2(32) Yes Gift card number.
START_BALANCE NUMBER(16,4) Yes Starting balance for the card for the transaction.
AMOUNT NUMBER(16,4) Yes Transaction amount.
END_BALANCE NUMBER(16,4) Yes Ending balance for the card for the transaction.
TXN_TYPE NUMBER(1) Yes Transaction type. 0=Add, 1=Redeem.
DOCUMENT_SID NUMBER(19) Yes Document SID
DOCUMENT_NO NUMBER(10) Yes Document number.
DOCUMENT_TOTAL NUMBER(16,4) Yes Document total.
EXP_DATE DATE Yes Gift card expiration date.
MAX_AMT NUMBER(16,4) Yes Max gift card limit amount.
CURRENCY_CODE NVARCHAR2(10) Yes Currency code.
CUSTOMER_NAME NVARCHAR2(50) Yes Customer name.
EMPLOYEE_NAME NVARCHAR2(50) Yes Employee name.

CHARGE_TERM

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant description.
SBS_SID NUMBER(19) No Reference to subsidiary.
TERM_ID NUMBER(10) No Identifies the payment term.
DISC_DAYS NUMBER(10) Yes Number of days to make payment to receive the defined DISC_PERC.
DISC_PERC NUMBER(16,4) Yes Discount percentage for paying within the defined DISC_DAYS.
NET_DAYS NUMBER(10) Yes Number of days when full payment (NET) is due.

COMMENTS

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
SBS_SID NUMBER(19) No Subsidiary SID.
DOC_TYPE NUMBER(5) No Document type. 1=Sales, 4=SO, 6=Slip, 7=Voucher, 8=Check In/Check Out, 9=Customer Store Credit, 10=PO Fee Types, 11=PO Instructions
COMMENTS NVARCHAR2(60) Yes Comment text.
ACTIVE NUMBER(1) No 0=inactive, 1=active
DEFAULT_VALUE DEFAUKT_VALUE(1) No 0=Not a default comment, 1=Default comment.
COMMENT_ORDER NUMBER(5) Yes Order in which comment will appear on the document.
COMMENT_ID NUMBER(10) No Identifies the comment

COMMISSION

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

COMPANY

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

CONSUMER_CACHE

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
FROM_SERVER NVARCHAR2(100) Yes From Server.
FROM_TYPE NVARCHAR2(20) Yes From Type.
COMPRESSED NUMBER(1) Yes Compressed? 0=No, 1=Yes. Default=0
RESOURCE_DATA CLOB Yes The resource data.
RESOURCE_NAME NVARCHAR2(50) Yes The resource name.
INIT NUMBER(1) Yes Part of initialization? 0=No, 1=Yes
PROCESS_ORDER NUMBER(5) Yes Replication process order.
STATUS NUMBER(4) No Replication status. Default=0
RETRIES NUMBER(4) No Number of retries. Default=0
SEQ NUMBER(19) Yes Sequence number.
REPLICATION_VERSION NUMBER(5) Yes Replication version
HEADERS NVARCHAR2(2000) Yes Header information.

CONSUMER_CACHE_ERROR

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
FROM_SERVER NVARCHAR2(100) Yes Server from which the resource in the consumer error cache was sent.
FROM_TYPE NVARCHAR2(20) Yes Type of server from which the resource was sent.
COMPRESSED NUMBER(1) Yes Compressed? 0=No, 1=Yes. Default=0
HEADERS CLOB Yes Header data.
RESOURCE_DATA CLOB Yes Resource data
RESOURCE_NAME NVARCHAR2(50) Yes The name of the resource that is in the consumer error cache.
INIT NUMBER(1) Yes Initialization? 0=No, 1=Yes.
PROCESS_ORDER NUMBER(5) Yes The resource's place in the replication process order.
STATUS NUMBER(4) No Replication status. Default=0

CONTACT_TYPE

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

CONTROLLER

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

COUNTRY

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

COUPON_SET

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

COUPON_SET_COUPON

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

CREDIT_CARD

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

CREDIT_CARD_EFT

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

CREDIT_CARD_TYPE

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

CREDIT_CARD_VALIDATION_RULE

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

CURRENCY

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

CURRENCY_DENOMINATION

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

CUSTOMER

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
DISTRICT_SID NUMBER(19) Yes Reference to customer's home district.
STORE_SID NUMBER(19) Yes Reference to customer's home store.
COMPANY_SID NUMBER(19) Yes Reference to customer's company.
CUST_ID NUMBER(14) Yes Identifies the customer.
SHARE_TYPE NUMBER(5) No Indicates how the record is shared: 0=local, 1=global, 2=region, 3=non-shared. Default=1
LAST_NAME NVARCHAR2(30) Yes Customer last name.
FIRST_NAME NVARCHAR2(30) Yes Customer first name.
ACTIVE NUMBER(1) No 0=inactive, 1=active.
MARKETING_FLAG NUMBER(1) Yes Marketing flag.
BIRTH_DAY NUMBER(5) Yes Day of customer's birthday.
BIRTH_MONTH NUMBER(5) Yes Month of customer's birthday.
BIRTH_YEAR NUMBER(10) Yes Year of customer's birthday.
CUST_TYPE NUMBER(5) Yes Indicates type of customer: 0=Custome (customer only), 1=employee
CUST_CLASS_SID NUMBER(19) Yes Reference to customer class description record.
TITLE_SID NUMBER(19) Yes Reference to person title record.
SUFFIX_SID NUMBER(19) Yes Reference to person suffix record (e.g., Jr. or PhD)
GENDER NUMBER(19) Yes 0=male, 1=female
PRICE_LVL_SID NUMBER(19) Yes If populated, overrides subsidiary/store price level.
TAX_AREA_SID NUMBER(19) Yes Reference to tax area record.
TAX_AREA2_SID NUMBER(19) Yes Reference to tax area record.
CREDIT_LIMIT NUMBER(16,4) Yes Maximum credit amount.
CREDIT_USED NUMBER(16,4) Yes Amount of credit used.
STORE_CREDIT NUMBER(16,4) Yes Customer's store credit balance.
ACCEPT_CHECKS NUMBER(1) Yes 0=customer cannot use check tender, 1=customer can use check tender.
CHECK_LIMIT NUMBER(16,4) Yes Maximum amount that can be accepted from customer in personal checks. null=unlimited
DETAX NUMBER(1) Yes Indicates customer is eligible for detax. (detax customers are typically diplomats, military, etc.; used in VAT environments)
SUGGESTED_DISC_PERC NUMBER(16,4) Yes Suggested discount available to this customer.
MAX_DISC_PERC NUMBER(16,4) Yes Maximum percentage that a customer's purchase can be discounted.
HOUSEHOLD_CODE NUMBER(10) Yes Additional filter used for lookups.
MARK1 NVARCHAR2(4) Yes Accounting system flag.
MARK2 NVARCHAR2(4) Yes Accounting system flag.
SECURITY_LVL NUMBER(5) Yes Customer security level (legacy feature)
AR_FLAG NUMBER(1) Yes Indicates status of last attempt to process customer information into accounting system. 1=Yes, 2=No, 3=Export.
RELATED_CUST_SID NUMBER(19) Yes Reference to associated customer record.
SHIPPING_PRIORITY   Yes Shipping priority.
PRIMARY_CLERK_SID NUMBER(19) Yes Reference to employee record.
FIRST_SALE_DATE DATE Yes Date of first purchase.
LAST_SALE_DATE DATE Yes Date of last purchase.
LAST_SALE_AMT NUMBER(16,4) Yes Amount of last purchase.
WSC_USERNAME NVARCHAR2(20) Yes Encrypted username.
WSC_PASSWORD NVARCHAR2(20) Yes Encypted password.
PAYMENT_TERMS_SID NUMBER(19) Yes Unique SID referencing payment terms.
ACCOUNTING_SYSTEM_ID NVARCHAR2(40) Yes String tag identifying this customer within the accounting system.
UDF1_STRING NVARCHAR2(50) Yes User-defined field.
UDF2_STRING NVARCHAR2(50) Yes User-defined field.
UDF3_STRING NVARCHAR2(50) Yes User-defined field.
UDF4_STRING NVARCHAR2(50) Yes User-defined field.
UDF5_STRING NVARCHAR2(50) Yes User-defined field.
EMAIL NVARCHAR2(100) Yes Email address.
UDF1_CLOB CLOB Yes User-defined field.
UDF2_CLOB CLOB Yes User-defined field.
NOTES CLOB Yes Freeform text field
IMAGE BLOB Yes customer image
INFO1 NVARCHAR2(20) Yes Legacy data entry field.
INFO2 NVARCHAR2(20) Yes Legacy data entry field.
QB_LINK NUMBER(1) Yes Indicates if a customer record is being exported to QuickBooks via QBLink.
CMS NUMBER(1) Yes Used to determine where the customer may have been created: RP8, RP9, or Prism
LAST_RETURN_DATE DATE Yes Last return date.
TOTAL_TRANSACTIONS NUMBER(10) Yes Total number of transactins.
SALE_ITEM_COUNT NUMBER(10) Yes A count of all items on a transaction that are marked as sale items.
RETURN_ITEM_COUNT NUMBER(10) Yes A count of all items on a transaction that are marked as return items.
SEGMENTED NUMBER(1) Yes 0=segment rules not completed, 1=segment rules completed
EMPLOYEE_AS_CUSTOMER NUMBER(1) No Indicates employee is customer or not to determine if an employee can be used as a customer.
LAST_ORDER_DATE DATE Yes Last order date.
ORDER_ITEM_COUNT NUMBER(10) Yes A count of all items being ordered.
STATION NCHAR(1) Yes Station code.
ALLOWED_TENDERS NVARCHAR2(20) Yes Array of flags used to indicate the tender types this customer is allowed to tender with.
COUNTRY_SID NUMBER(19) Yes Customer SID.
PROMO_CUSTLISTNAME NVARCHAR2(255) Yes Promotions: Customer Pricing List Name.
CENTRAL_CREDIT NUMBER(16,4) Yes Customer central credit balance.
LTY_OPT_IN NUMBER(1) Yes 0=customer opt out, 1=customer opt in
LTY_ENROLL_DATE DATE Yes The date the customer enrolls in the customer loyalty program.
LTY_BALANCE NUMBER(24,8) Yes The customer loyalty balance as updated by the centrals server.
LTY_ACCUMULATED NUMBER(24,8) Yes The accumulated points accrued for either YTD from the enroll date or total lifetime.
LTY_LVL_SID NUMBER(19) Yes Unique identifier of the customer loyalty levels.
LTY_LVL_LOCKED NUMBER(1) Yes To indicate whether the Loyalty Level for the customer can be changed or not. 0 (or null)=Unlocked, 1=Locked
LTY_OPT_IN_MANUAL NUMBER(1) Yes Indicates manual opt-in to loyalty program.
ALTERNATE_ID1 NVARCHAR2(20) Yes Alternate ID
ALTERNATE_ID2 NVARCHAR2(20) Yes Alternate ID
UDF1_DATE DATE Yes User-defined date.
UDF2_DATE DATE Yes User-defined date.
EXTERNAL_TRANSFER_STATUS NVARCHAR2(255) Yes Only for external apps usage for tracking data transfer status
CENTRAL_CURRENCYCODE NVARCHAR2(10 Yes Central credit currency code.

CUSTOMER_ADDRESS

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
CUST_SID NUMBER(19) No Reference to customer record.
PRIMARY_FLAG NUMBER(1) No Indicates that this is the customer's primary address.
ACTIVE NUMBER(1) No Indicates that this address can be used in the workflow. 0=inactive, 1=active. Default=1
ADDRESS_NAME NVARCHAR2(30) Yes Descriptive name of the address as it relates to the customer.
COMPANY_NAME NVARCHAR2(100) Yes Optional name of company at this address
ADDRESS_1 NVARCHAR2(40) Yes Address line 1: Number and street.
ADDRESS_2 NVARCHAR2(40) Yes Address line 2: Suite or apartment number
ADDRESS_3 NVARCHAR2(40) Yes Address line 3: c/o
CITY NVARCHAR2(40) Yes City
STATE NVARCHAR2(5) Yes State
POSTAL_CODE NVARCHAR2(10) Yes ZIP Code or Postal Code
POSTAL_CODE_EXTENSION NVARCHAR2(5) Yes ZIP Code extension
COUNTRY_SID NUMBER(19) Yes Reference to country record.
BEGIN_DATE DATE Yes Date customer began living at or using this address.
END_DATE DATE Yes Date customer stopped living at or using this address.
SEASONAL_BEGIN_DATE DATE Yes If the customer uses this address seasonally, month and day the customer begins using this address.
SEASONAL_END_DATE DATE Yes If the customer uses this address seasonally, month and day the customer stops using this address.
ADDRESS_TYPE_SID NUMBER(19) Yes Reference to address type record.
ADDRESS_CODE NVARCHAR2(10) Yes Short descriptive code for this address (e.g., HOME)
BILL_SHIP NUMBER(1) Yes 0=billing, 1=shipping.
PHONE_SID NUMBER(19) Yes Reference to phone record.
ALT_PHONE_SID NUMBER(19) Yes Reference to phone record.
ADDRESS_ALLOW_CONTACT NUMBER(1) No Indicates customer has opted out of being contacted. 0=No contact allowed, 1=Contact allowed. Default=0
ADDRESS_4 NVARCHAR2(40) Yes Extended address detail.
ADDRESS_5 NVARCHAR2(40) Yes Extended address detail.
ADDRESS_6 NVARCHAR2(40) Yes Extended address detail.
TAX_AREA_SID NUMBER(19) Yes Each address that is created can have a certain tax area.
TAX_AREA2_SID NUMBER(19) Yes Each address that is created can have a certain tax area.
ADDRESS_LINE1 NVARCHAR2(40) Yes Address line 1. Typically the street number and street name (e.g., 123 Main St.)
SEQ_NO NUMBER(5) No The address' position in the list of addresses.

CUSTOMER_CLASS

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
CUST_CLASS_NAME NVARCHAR2(30) No Short descriptive name for customer class.

CUSTOMER_CONTACT_HISTORY

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
CUST_SID NUMBER(19) No Reference to customer record.
CONTACT_TYPE_SID NUMBER(19) Yes Reference to customer contact type record.
CONTACT_DATE DATE Yes Date to contact. This is different from the created_datetime because the date of contact may have been in the past.
NEXT_CONTACT_DATE DATE Yes Date next contact has been scheduled for.
UDF1_STRING NVARCHAR2(50) Yes User-defined field.
UDF2_STRING NVARCHAR2(50) Yes User-defined field.
UDF3_STRING NVARCHAR2(50) Yes User-defined field.
UDF4_STRING NVARCHAR2(50) Yes User-defined field.
UDF5_STRING NVARCHAR2(50) Yes User-defined field.
NOTES CLOB Yes Text field.

CUSTOMER_CREDIT_CARD

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

CUSTOMER_DOCUMENT_HISTORY

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

CUSTOMER_EMAIL

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

CUSTOMER_EXTEND

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

CUSTOMER_PHONE

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

CUSTOMER_UDF

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

CUSTOMER_UDF_OPTION

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

CUSTOMIZATION

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

CUSTOM_SCHEMA

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

CUST_CENTRAL_CREDIT_BAL_TEMP

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

DCS

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

DISTRICT

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

DOCUMENT

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Nullable Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
STATUS NUMBER(1) No 0=None, 1=changed, 2=cancelled, 3=normal, 4=comleted
USE_VAT NUMBER(1) No Flag to indicate the  document uses VAT.
WAS_AUDITED NUMBER(1) No Indicates document was audited.
IS_HELD NUMBER(1) No Indicates document is in a held state pending future changes. Business rules for completion of a document do not apply to a held document, and totals from a held document are not included in daily totals reports.
DETAX_FLAG NUMBER(1) No Indicates tax has been removed from the document.
ARCHIVED NUMBER(1) No Indicates record has been archived.
TENDER_TYPE NUMBER(1) Nullable 0=cash, 1=check, 2=credit card, 3=COD, 4=charge, 5=store credit, 6=split tender, 7=deposit, 8=payments, 9=gift certificate, 10=gift card, 11=debit card, 12=foreign currency, 13=traveler's check, 14=foreign check, 15=central gift card, 16=central gift certificate, 17=central customer credit, 18=central customer loyaly
SBS_NO NUMBER(5) No Subsidiary number.
STORE_NO NUMBER(5) No Store number.
BT_PRIMARY NUMBER(1) No Indicates the address is the Bill To customer's primary address.
ST_PRIMARY NUMBER(1) No Indicates the address is the Ship To customer's primary address.
TENANT_SID NUMBER(19) Nullable Reference to tenant description.
DOC_NO NUMBER(10) Nullable Document identifying number; assigned when the document is posted or held.
DOC_REF_NO NUMBER(10) Nullable Document number of another document referenced by this document.
TRACKING_NO NVARCHAR(24) Nullable Tracking number assigned by the carrier (e.g., UPS).
VAT_OPTIONS NUMBER(10) Nullable Bitmask containing VAT rules.
CUST_PO_NO NVARCHAR2(10) Nullable Customer purchase order number.
DISC_PERC NUMBER(16,4) Nullable Document-level discount percentage. If not null, supercedes DISC_AMT.
DISC_AMT NUMBER(16,4) Nullable Document-level discount amount. Used if DISC_PERC is null.
TAX_REBATE_PERC NUMBER(17,5) Nullable Tax rebate percentage. If not null, supercedes TAX_REBATE_AMT.
TAX_REBATE_AMT NUMBER(16,4) Nullable Tax rebate amount. Used if TAX_REBATE_PERC is null.
OVER_TAX_PERC NUMBER(16,4) Nullable N/A
OVER_TAX_PERC2 NUMBER(16,4) Nullable N/A
ROUNDING_OFFSET NUMBER(16,4) Nullable N/A
WS_SEQ_NO NUMBER(19) Nullable Document sequence number assigned by the workstation.
CUST_FIELD NVARCHAR2(47) Nullable Legacy field from V9.
DRAWER_NO NUMBER(5) Nullable Drawer number, either 1 or 2. Should this be the
ELAPSED_TIME NUMBER(10) Nullable Number of seconds elapsed from time invoice was begun to the time it was posted. Does not include amount of time document was on hold.
ACTIVITY_PERC NUMBER(16,4) Nullable Percentage of work done onn this transaction by employee referenced by CLERK_SID.
ACTIVITY2_PERC NUMBER(16,4) Nullable Percentage of work done on this transaction by employee referenced by CLERK2_SID.
ACTIVITY3_PERC NUMBER(16,4) Nullable Percentage of work done on this transaction by employee referenced by CLERK3_SID.
ACTIVITY4_PERC NUMBER(16,4) Nullable Percentage of work done on this transaction by employee referenced by CLERK4_SID.
ACTIVITY5_PERC NUMBER(16,4) Nullable Percentage of work done on this transaction by employee referenced by CLERK5_SID.
EFT_INVC_NO NUMBER(10) Nullable Invoice number generated to satisfy eft processor requirements.
SHIPPING_PERC NUMBER(16,4) Nullable Shipping percentage.
DISC_PERC_SPREAD NUMBER(16,4) Nullable Percentage of the document-level discount amount that was spread to items..
FISCAL_DOC_NO NUMBER(10) Nullable Number returned by fiscal printer as the reference number assigned to the document in the fiscal printer memory.
UDF1_STRING NVARCHAR2(210) Nullable User-defined field.
UDF2_STRING NVARCHAR2(210) Nullable User-defined field.
UDF3_STRING NVARCHAR2(210) Nullable User-defined field.
UDF4_STRING NVARCHAR2(210) Nullable User-defined field.
UDF5_STRING NVARCHAR2(210) Nullable User-defined field.
UDF1_FLOAT NUMBER(16,4) Nullable User-defined numeric field.
UDF2_FLOAT NUMBER(16,4) Nullable User-defined numeric field.
UDF3_FLOAT NUMBER(16,4) Nullable User-defined numeric field.
UDF4_FLOAT NUMBER(16,4) Nullable User-defined numeric field.
UDF5_FLOAT NUMBER(16,4) Nullable User-defined numeric field.
UDF_CLOB CLOB Nullable User-defined clob field.
TOTAL_FEE_AMT NUMBER(16,4) Nullable Total fee amount.
TOTAL_DISCOUNT_AMT NUMBER(16,4) Nullable Total discount amount.
SALE_TOTAL_TAX_AMT NUMBER(17,5) Nullable Total tax amount for the sale items in the transaction.
SALE_TOTAL_AMT NUMBER(16,4) Nullable Total amount for the sale items in the transaction.
SALE_SUBTOTAL NUMBER(16,4) Nullable Subtotal amount for the sale items in the transaction.
DEPOSIT_AMT_REQUIRED NUMBER(16,4) Nullable Deposit amount required. 1=Yes, 0=No
DUE_AMT NUMBER(16,4) Nullable Balance Due.
SOLD_QTY NUMBER(10,3) Nullable Total sold quantity.
RETURN_QTY NUMBER(10,3) Nullable Total return quantity.
ORDER_QTY NUMBER(10,3) Nullable Total order quantity.
TAKEN_AMT NUMBER(16,4) Nullable Taken amount.
STORE_CODE NVARCHAR2(5) Nullable Store code.
ORIG_STORE_NO NUMBER(5) Nullable Original Store No at time of document creation.
ORIG_STORE_CODE NVARCHAR2(5) Nullable Original Store Code at time of document creation.
TAX_AREA_NAME NVARCHAR2(11) Nullable Tax area name.
TAX_AREA2_NAME NVARCHAR2(11) Nullable In multi-tax environment, the name of Tax ARea 2
DISCOUNT_REASON_NAME NVARCHAR2(80) Nullable Discount reason name.
WORKSTATION_NO NVARCHAR2(80) Nullable Keeps the number of the workstation the document was created at.
CASHIER_LOGIN_NAME NVARCHAR2(30) Nullable Keeps the login name of the cashier who created the document.
CASHIER_FULL_NAME NVARCHAR2(60) Nullable Keeps the full name of the cashier who created the document.
EMPLOYEE1_LOGIN_NAME NVARCHAR2(30) Nullable Keeps the login name of the cashier (employee) who created the document.
EMPLOYEE1_FULL_NAME NVARCHAR2(60) Nullable Keeps the full name of the cashier (employee) who created the document.
EMPLOYEE2_LOGIN_NAME NVARCHAR2(30) Nullable Keeps the login name of the clerk2 (employee) who created the document.
EMPLOYEE2_FULL_NAME NVARCHAR2(60) Nullable Keeps the full name of the clerk2 (employee) who created the document.
EMPLOYEE3_LOGIN_NAME NVARCHAR2(30) Nullable Keeps the login name of the clerk3 (employee) who created the document.
EMPLOYEE3_FULL_NAME NVARCHAR2(60) Nullable Keeps the full name of the clerk3 (employee) who created the document.
EMPLOYEE4_LOGIN_NAME NVARCHAR2(30) Nullable Keeps the login name of the clerk4 (employee) who created the document.
EMPLOYEE4_FULL_NAME NVARCHAR2(60) Nullable Keeps the full name of the clerk4 who created the document.
EMPLOYEE5_LOGIN_NAME NVARCHAR2(30) Nullable Keeps the login name of the clerk5 who created the document.
EMPLOYEE5_FULL_NAME NVARCHAR2(60) Nullable Keeps the full name of the clerk5 who created the document.
BT_CUID NUMBER(19) Nullable Keeps the bill to customer unique identifier on the document.
BT_ID NUMBER(14) Nullable Bill To Customer ID.
BT_LAST_NAME NVARCHAR2(30) Nullable Bill To Customer last name.
BT_FIRST_NAME NVARCHAR2(30) Nullable Bill To Customer first name.
BT_COMPANY_NAME NVARCHAR2(100) Nullable Bill To Customer company name.
BT_TITLE NVARCHAR2(15) Nullable Bill To Customer title (Mr., Mrs., etc.)
BT_TAX_AREA_NAME NVARCHAR2(11) Nullable Bill To Customer tax area name.
BT_TAX_AREA2_NAME NVARCHAR2(11) Nullable In multi-tax environments, a second tax area assigned to the cusotmer.
BT_DETAX_FLAG NUMBER(1) Nullable Indicates if the Bill To customer is a detax customer (eligible for detax).
BT_PRICE_LVL_NAME NVARCHAR2(6) Nullable Name assigned to the price level assigned to Bill To customerm
BT_PRICE_LVL NUMBER(5) Nullable Indicates the price level assigned to the customer.
BT_SECURITY_LVL NUMBER(5) Nullable Indicates the security level assigned to the customer.
BT_PRIMARY_PHONE_NO NVARCHAR2(30) Nullable Bill To customer primary phone number.
BT_ADDRESS_LINE1 NVARCHAR2(40) Nullable Bill To customer address line.
BT_ADDRESS_LINE2 NVARCHAR2(40) Nullable Bill To customer address line.
BT_ADDRESS_LINE3 NVARCHAR2(40) Nullable Bill To customer address line.
BT_ADDRESS_LINE4 NVARCHAR2(40) Nullable Bill To customer address line.
BT_ADDRESS_LINE5 NVARCHAR2(40) Nullable Bill To customer address line.
BT_ADDRESS_LINE6 NVARCHAR2(40) Nullable Bill To customer address line.
BT_COUNTRY NVARCHAR2(35) Nullable Bill To customer country.
BT_POSTAL_CODE NVARCHAR2(10) Nullable Postal code for the Bill To Customer's address.
BT_POSTAL_CODE_EXTENSION NVARCHAR2(5) Nullable Exension for the postal code.
ST_ADDRESS_LINE1 NVARCHAR2(40) Nullable Ship To customer address line.
ST_ADDRESS_LINE2 NVARCHAR2(40) Nullable Ship To customer address line.
ST_ADDRESS_LINE3 NVARCHAR2(40) Nullable Ship To customer address line.
ST_ADDRESS_LINE4 NVARCHAR2(40) Nullable Ship To customer address line.
ST_ADDRESS_LINE5 NVARCHAR2(40) Nullable Ship To customer address line.
ST_ADDRESS_LINE6 NVARCHAR2(40) Nullable Ship To customer address line.
ST_COUNTRY NVARCHAR2(35) Nullable Ship To customer's country.
ST_POSTAL_CODE NVARCHAR2(10) Nullable Postal code for the Ship To customer's address.
ST_POSTAL_CODE_EXTENSION NVARCHAR2(5) Nullable Extension for the postal code of the Ship To customer.
ST_CUID NUMBER(19) Nullable Keeps the ship to customer unique identifier on the document.
ST_LAST_NAME NVARCHAR2(30) Nullable Ship To customer last name.
ST_FIRST_NAME NVARCHAR2(30) Nullable Ship To customerr first name.
ST_TITLE NVARCHAR2(15) Nullable Ship To customer title (e.g., Mr., Mrs., Ms.)
ST_TAX_AREA_NAME NVARCHAR2(11) Nullable Name of tax area assigned to Ship To customer.
ST_TAX_AREA2_NAME NVARCHAR2(11) Nullable In multi-tax environment, name of second tax area assigned to the Ship To customer.
ST_DETAX_FLAG NUMBER(1) Nullable Indicates if the Ship To customer is a detax customer (eligible for detax).
ST_PRICE_LVL_NAME NVARCHAR2(6) Nullable Name of price level assigned to the Ship To customer.
ST_PRICE_LVL NUMBER(5) Nullable Indicates the price level of the Ship To customer.
ST_SECURITY_LVL NUMBER(5) Nullable Indicates the security level assigned to the Ship To customer.
ST_PRIMARY_PHONE_NO NVARCHAR2(30) Nullable Ship To customer primary phone number.
ST_COMPANY_NAME NVARCHAR2(100) Nullable Name of Ship To customer's company.
FEE_TYPE1 NUMBER(5) Nullable Keeps the type of fee the document might have.
FEE_NAME1 NVARCHAR2(25) Nullable Keeps the name of fee the document might have.
FEE_TYPE2 NUMBER(5) Nullable Keeps the type of fee the document might have.
FEE_NAME2 NVARCHAR2(25) Nullable Keeps the name of fee the document might have.
FEE_TYPE3 NUMBER(5) Nullable Keeps the type of fee the document might have.
FEE_NAME3 NVARCHAR2(25) Nullable Keeps the name of fee the document might have.
FEE_TYPE4 NUMBER(5) Nullable Keeps the type of fee the document might have.
FEE_NAME4 NVARCHAR2(25) Nullable Keeps the name of fee the document might have.
FEE_TYPE5 NUMBER(5) Nullable Keeps the type of fee the document might have.
FEE_NAME5 NVARCHAR2(25) Nullable Keeps the name of fee the document might have.
TENDER_NAME NVARCHAR2(25) Nullable Keeps the name of the tender the document was tendered with.
CURRENCY_NAME NVARCHAR2(30) Nullable Keeps the name of the currency the document was tendered with
TILL_NAME NVARCHAR2(40) Nullable keeps the name of the till the document was tendered with
BT_EMAIL NVARCHAR2(100) Nullable Email address of the Bill To customer.
ST_EMAIL NVARCHAR2(100) Nullable Email address of the Ship To customer.
HIST_DISC_AMT1 NUMBER(16,4) Nullable Tracks discount information for the document.
HIST_DISC_PERC1 NUMBER(16,4) Nullable Tracks discount information for the document.
HIST_DISC_REASON1 NVARCHAR2(80) Nullable Tracks discount information for the document.
HIST_DISC_AMT2 NUMBER(16,4) Nullable Tracks discount information for the document.
HIST_DISC_PERC2 NUMBER(16,4) Nullable Tracks discount information for the document.
HIST_DISC_REASON2 NVARCHAR2(80) Nullable Tracks discount information for the document.
HIST_DISC_AMT3 NUMBER(16,4) Nullable Tracks discount information for the document.
HIST_DISC_PERC3 NUMBER(16,4) Nullable Tracks discount information for the document.
HIST_DISC_REASON3 NVARCHAR2(80) Nullable Tracks discount information for the document.
HIST_DISC_AMT4 NUMBER(16,4) Nullable Tracks discount information for the document.
HIST_DISC_PERC4 NUMBER(16,4) Nullable Tracks discount information for the document.
HIST_DISC_REASON4 NVARCHAR2(80) Nullable Tracks discount information for the document.
HIST_DISC_AMT5 NUMBER(16,4) Nullable Tracks discount information for the document.
HIST_DISC_PERC5 NUMBER(16,4) Nullable Tracks discount information for the document.
HIST_DISC_REASON5 NVARCHAR2(80) Nullable Tracks discount information for the document.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time row was created.
POST_DATE TIMESTAMP(0) WITH TIME ZONE Nullable Date/time row was created/last modified in this system. May not be the same as created/modified datetime.
UDF1_DATE TIMESTAMP(0) WITH TIME ZONE Nullable User-defined date field.
UDF2_DATE TIMESTAMP(0) WITH TIME ZONE Nullable User-defined date field.
UDF3_DATE TIMESTAMP(0) WITH TIME ZONE Nullable User-defined date field.
INVC_POST_DATE TIMESTAMP(0) WITH TIME ZONE Nullable Date the invoice was posted. Note this is not the same as the post_date in the standard header.
FEE_TAX_INCLUDED1 NUMBER(1) Nullable Indicates tax is included on the fee. 0=not included, 1= included
FEE_TAX_PERC1 NUMBER(16,4) Nullable Fee tax percentage.
FEE_TAX_INCLUDED2 NUMBER(1) Nullable Indicates tax is included on the fee. 0=not included, 1= included
FEE_TAX_PERC2 NUMBER(16,4) Nullable Fee tax percentage.
FEE_TAX_INCLUDED3 NUMBER(1) Nullable Indicates tax is included on the fee. 0=not included, 1= included
FEE_TAX_PERC3 NUMBER(16,4) Nullable Fee tax percentage.
FEE_TAX_INCLUDED4 NUMBER(1) Nullable Indicates tax is included on the fee. 0=not included, 1= included
FEE_TAX_PERC4 NUMBER(16,4) Nullable Fee tax percentage.
FEE_TAX_INCLUDED5 NUMBER(1) Nullable Indicates tax is included on the fee. 0=not included, 1= included
FEE_TAX_PERC5 NUMBER(16,4) Nullable Fee tax percentage.
PRICE_LVL NUMBER(5) Nullable Stores the price level on the document.
PRICE_LVL_NAME NVARCHAR2(6) Nullable Stores the name of the price level on the document.
SHIPPING_AMT NUMBER(16,4) Nullable Stores the shipping amount.
SHIPPING_TAX_PERC NUMBER(16,4) Nullable Stores the tax percent of the shipping amount.
SHIPPING_TAX_AMT NUMBER(16,4) Nullable Stores shipping tax amount.
SHIP_METHOD NVARCHAR2(20) Nullable Stores description of how items are shipped.
CANCEL_ORDER NUMBER(1) Nullable Indicates if the document will cancel the referenced order upon update.
ROUNDED_DUE_AMT NUMBER(16,4) Nullable Suggested rounded next tender amount.
ORDER_QUANTITY_FILLED NUMBER(10,3) Nullable Quantity of an order document that has already been filled.
OVERRIDE_MAX_DISC_PERC NUMBER(16,4) Nullable Override maximum employee discount percent for all items on the document.
ORDER_TOTAL_TAX_AMT NUMBER(17,5) Nullable Stores total tax amount for the order items in the transaction.
TRANSACTION_TOTAL_TAX_AMT NUMBER(17,5) Nullable Stores total tax amount for the transaction.
SALE_TAX1_AMT NUMBER(17,5) Nullable Stores Tax1 amount for the sale items in the transaction.
ORDER_TAX1_AMT NUMBER(17,5) Nullable Stores Tax1 amount for the order items in the transaction.
TRANSACTION_TAX1_AMT NUMBER(17,5) Nullable Tax1 amount for the transaction.
SALE_TAX2_AMT NUMBER(17,5) Nullable Stores Tax2 amount for the sale items in the transaction.
ORDER_TAX2_AMT NUMBER(17,5) Nullable Stores Tax2 amount for the order items in the transaction.
TRANSACTION_TAX2_AMT NUMBER(17,5) Nullable Stores Tax1 amount for the transaction.
ORDER_TOTAL_AMT NUMBER(16,4) Nullable Stores total amount for the order items in the transaction.
TRANSACTION_TOTAL_AMT NUMBER(16,4) Nullable Stores total amount for the transaction.
ORDER_SUBTOTAL NUMBER(16,4) Nullable Stores subtotal amount for the order items in the transaction.
SALE_SUBTOTAL_WITH_TAX NUMBER(16,4) Nullable Stores subtotal with tax for the sale items in the transaction.
TRANSACTION_SUBTOTAL_WITH_TAX NUMBER(16,4) Nullable Stores subtotal with tax for the transaction.
SO_DEPOSIT_AMT NUMBER(16,4) Nullable (Obsolete)
SO_DEPOSIT_AMT_PAID NUMBER(16,4) Nullable Stores deposit amount that is paid for the transaction.
TOTAL_LINE_ITEM NUMBER(10) Nullable Stores the number of line items for the transaction.
TOTAL_ITEM_COUNT NUMBER(10) Nullable Stores the total item count for the transaction.
TRANSACTION_SUBTOTAL NUMBER(16,4) Nullable Stores the subtotal for the transaction
GIVEN_AMT NUMBER(16,4) Nullable Keeps the given amount for the document.
FEE_AMT1 NUMBER(16,4) Nullable Stores the fee amount.
FEE_TAX_AMT1 NUMBER(16,4) Nullable Stores the fee tax amount.
FEE_AMT2 NUMBER(16,4) Nullable Stores the fee amount.
FEE_TAX_AMT2 NUMBER(16,4) Nullable Stores the fee tax amount.
FEE_AMT3 NUMBER(16,4) Nullable Stores the fee amount.
FEE_TAX_AMT3 NUMBER(16,4) Nullable Stores the fee tax amount.
FEE_AMT4 NUMBER(16,4) Nullable Stores the fee amount.
FEE_TAX_AMT4 NUMBER(16,4) Nullable Stores the fee tax amount.
FEE_AMT5 NUMBER(16,4) Nullable Stores the fee amount.
FEE_TAX_AMT5 NUMBER(16,4) Nullable Stores the fee tax amount.
SHHIPPING_TAX_INCLUDED NUMBER(1) Nullable Indicates if shipping tax should be included in the document.
WORKSTATION_UID NUMBER(UID) Nullable Keeps the workstation unique identifier on the document.
WORKSTATION_NAME NVARCHAR2(64) Nullable Keeps the name of the workstation the document was created at.
STORE_NAME NVARCHAR2(40) Nullable Store name on the document.
TAX_AREA_PERC NUMBER(16,4) Nullable Used to store tax area 1 percentage on the document
TAX_AREA2_PERC NUMBER(16,4) Nullable Used to store tax area 2 percentage on the document
TAX_AREA_AMT NUMBER(16,4) Nullable Used to store tax area 1 amount on the document
TAX_AREA2_AMT NUMBER(16,4) Nullable Used to store tax area 2 amount on the document
TAX_AREA_SALES_TAX_AMT NUMBER(16,4) Nullable Used to store tax area 1 sales tax amount on the document.
TAX_AREA2_SALES_TAX_AMT NUMBER(16,4) Nullable Used to store tax area 2 sales tax amount on the document.
TAX_AREA_ORDER_TAX_AMT NUMBER(16,4) Nullable Used to store tax area 1 order tax amount on the document.
TAX_AREA2_ORDER_TAX_AMT NUMBER(16,4) Nullable Used to store tax area 2 order tax amount on the document.
REASON_CODE NVARCHAR2(80) Nullable Predefined reason code on document.
REASON_DESCRIPTION NVARCHAR2(80) Nullable Predefined reason description on document.
POS_FLAG1 NVARCHAR2(60) Nullable POS Flag 1 on document.
POS_FLAG2 NVARCHAR2(60) Nullable POS Flag 2 on document.
POS_FLAG3 NVARCHAR2(60) Nullable POS Flag 3 on document.
COMMENT1 NVARCHAR2(255) Nullable Comment 1 text.
COMMENT2 NVARCHAR2(255) Nullable Comment 2 text.
NOTES NVARCHAR2(255) Nullable Note text.
DEPOSIT_AMT_TAKEN NUMBER(16,4) Nullable (obsolete)
DEPOSIT_REF_DOC_SID NUMBER(19) Nullable Used to indicate the source document for additional deposit.
TOTAL_DEPOSIT_TAKEN NUMBER(16,4) Nullable Reflects the total for all deposits taken for the document.
SUBSIDIARY_SID NUMBER(19) Nullable Indicates the Subsidiary of the document.
STORE_SID NUMBER(19) Nullable Indicates the Store for the document.
NOTES_GENERAL NVARCHAR2(255) Nullable General notes for the document.
NOTES_ORDER NVARCHAR2(255) Nullable Order notes for the document.
NOTES_SALE NVARCHAR2(255) Nullable Sales notes for the document.
NOTES_RETURN NVARCHAR2(255) Nullable Return notes for the document.
NOTES_LOSTDOC NVARCHAR2(255) Nullable Lost sale notes for the document.
SHIP_PARTIAL NUMBER(1) Nullable Flag to determine if items can be split across sipments.
SHIP_PRIORITY NUMBER(5) Nullable Priority assigned to the order. 0=Low, 1=Medium, 2=High.
TILL_SID NUMBER(19) Nullable Reference to unique identifier for the till.
CASHIER_SID NUMBER(19) Nullable Reference to unique identifier for the employee recorded in the Cashier field on the document.
EMPLOYEE1_SID NUMBER(19) Nullable Reference to unique identifier for the employee
EMPLOYEE2_SID NUMBER(19) Nullable Reference to unique identifier for the employee
EMPLOYEE3_SID NUMBER(19) Nullable Reference to unique identifier for the employee
EMPLOYEE4_SID NUMBER(19) Nullable Reference to unique identifier for the employee
EMPLOYEE5_SID NUMBER(19) Nullable Reference to unique identifier for the employee
EXCHANGE_QTY NUMBER(10,3) Nullable Total exchange quantity.
DISCOUNT_TYPE NUMBER(1) Nullable Indicates what type of discount was applied to sale/return part of the document: 0=initial value, 1=discount amount, 2=discount percentage
REF_ORDER_SID NUMBER(19) Nullable Keeps the reference to the document to fulfill.
ORDER_DISC_PERC NUMBER(16,4) Nullable Discount percentage for the order items on the document.
ORDER_DISC_AMT NUMBER(16,4) Nullable Discount amount for the order items on the document.
ORDER_DISCOUNT_REASON_NAME NVARCHAR2(80) Nullable Discount reason for order items.
ORDER_DISCOUNT_TYPE NUMBER(1) Nullable Discount type for order items. 0=initial value, 1=discount amount, 2=discount percentage
SO_CANCEL_FLAG NUMBER(1) Nullable Indicates the SO was cancelled.
TOTAL_DEPOSIT_USED NUMBER(16,4) Nullable Total amount of deposits used on the document.
ORDER_FEE_TYPE1_SID NUMBER(19) Nullable Unique identifier for Order Fee Type.
ORDER_SHIPPING_SID NUMBER(19) Nullable Unique identifier for shipping reason.
ORDER_SHIPPING_PERC NUMBER(16,4) Nullable Shipping percentage applied to the order portion of the document.
ORDER_DOC_NO NUMBER(10) Nullable Document number of the order referenced on the document.
USED_DISC_AMT NUMBER(16,4) Nullable Amount of discounts used on the document.
USED_SUBTOTAL NUMBER(16,4) Nullable Subtotal
USED_TAX NUMBER(17,5) Nullable Tax amount used on the document.
USED_FEE_AMT1 NUMBER(16,4) Nullable Fee amount used on the document.
USED_SHIPPING_AMT NUMBER(16,4) Nullable Shipping amount used on the document.
ORDER_CHANGED_FLAG NUMBER(1) Nullable Flag to indicate the order was changed after it was created.
PROMO_GDMANDISC NUMBER(1) Nullable Global discount amount from promotions on the document.
ORIGINAL_STORE_SID NUMBER(19) Nullable The SID of the store where the document was originally created.
RECEIPT_TYPE NUMBER(2) Nullable Receipt type.
ORDER_TYPE NUMBER(2) Nullable Order type. 0=customer order, 1=layaway, 2=special order
HAS_SALE NUMBER(1) Nullable 0=no sale items on document, 1=sale items on document.
HAS_RETURN NUMBER(1( Nullable 0=no return items on document, 1=return items on document.
HAS_DEPOSIT NUMBER(1) Nullable 0=no deposit on document, 1=deposit on document.
ORDER_SHIP_METHOD_SID NUMBER(19) Nullable Unique identifier for the order shipping method.
ORDER_SHIP_METHOD_ID NUMBER(5) Nullable Identifies the shipping method for the order items on the document
ORDER_SHIP_METHOD NVARCHAR2(20) Nullable Shipping method for the order portion of the document.
SHIP_METHOD_SID NUMBER(19) Nullable Unique identifier for the shipping method.
SHIP_METHOD_ID NUMBER(5) Nullable Identifies the shipping method.
SS_COPY NUMBER(1) Nullable Indicates a Send Sale copy.
SS_STATUS NUMBER(3) Nullable Send  Sale status.
SS_LAST_EVENT_ERROR TIMESTAMP(0) WITH TIME ZONE Nullable Timestamp of the most recent error on a send sale.
SS_LAST_ERROR NVARCHAR3(500) Nullable Error message associated with the most recent error on a send sale.
SS_FULFILLMENT NUMBER(1) Nullable 0=Send sale not fulfilled, 1=Send sale fulfilled.
DETAX_AMT NUMBER(17,5) Nullable Detax amount.
ORDER_SHIPPING_AMT_MANUAL NUMBER(16,4) Nullable Shipping amount manually entered for the order.
SHIPPING_AMT_MANUAL NUMBER(16,4) Nullable Shipping amount manually entered for the sale.
ORDER_SHIPPING_AMT_MANUAL_USED NUMBER(16,4) Nullable Indicates the amount used of the order shipping amount.
ORDER_TRACKING_NO NVARCHAR2(24) Nullable Tracking number for the shipment assigned by the carrier (e.g., FEDEX.
ORDER_STATUS NUMBER(1) No Order status.
TAX_REBATE_PERSISTED NUMBER(1) Nullable 0 = no tax rebate applied, 2 =tax rebate applied, 3 = tax rebate applied and persisted
RETURN_SUBTOTAL NUMBER(16,4) Nullable Return subtotal.
RETURN_SUBTOTAL_WITH_TAX NUMBER(17,5) Nullable Return subtotal with tax.
RETURN_TAX1_AMT NUMBER(17,5) Nullable Tax 1 amount.
RETURN_TAX2_AMT NUMBER(17,5)   In multi-tax environments, the tax amount of the Tax 2 on the document.
RETURN_TOTAL_TAX_AMT NUMBER(17,5) Nullable Total tax amount of the return items on the document.
SHIPPING_AMT_MANUAL_BDT NUMBER(16,4) Nullable  
ORDER_SHIPPING_AMT_MANUAL_BDT NUMBER(16,4) Nullable  
FEE_AMT1_BDT NUMBER(16,4) Nullable  
ORDER_FEE_AMT1_BDT NUMBER(16,4) Nullable  
REFUND_DOCUMENT_SID NUMBER(19) Nullable  
REF_ORDER_BALANCE_DUE NUMBER(16,4) Nullable  
REF_ORDER_ORDER_DOC_NO NUMBER(10) Nullable  
LTY_PGM_SID NUMBER(19) Nullable Unique identifier for loyalty program used on the document.
LTY_PGM_NAME NVARCHAR2(40) Nullable Name of loyalty program used on the document.
LTY_START_BALANCE NUMBER(24,8) Nullable Loyalty points start balance.
LTY_END_BALANCE NUMBER(24,8) Nullable Loyalty points end balance.
LTY_REDEEM_AMT NUMBER(16,4) Nullable Amount of loyalty points redeemed.
LTY_GIFT_AMT NUMBER(16,4) Nullable Loyalty gift amount.
LTY_LVL_SID NUMBER(19) Nullable Unique identifier for loyalty level.
LTY_PERC_REWARD_DISC_PERC NUMBER(16,4) Nullable Loyalty percentable reward discount percentage
LTY_PERC_REWARD_DISC_AMT NUMBER(16,4) Nullable Loyalty percentable reward discount amount
LTY_CENTRAL_STATUS NUMBER(1) Nullable Loyalty centrals server status.
LTY_PGM_SID2 NUMBER(19) Nullable Unique identifier for second loyalty program on the document.
LTY_PGM_NAME2 NVARCHAR2(40) Nullable Name of a second loyalty program used on the document.
LTY_PGM_SID3 NUMBER(19) Nullable  
LTY_PGM_NAME3 NVARCHAR2(40) Nullable Name of a third loyalty program used on the document.
LTY_ITEM_GIFT_PGM_SID NUMBER(19) Nullable Unique identifier
LTY_ITEM_GIFT_PGM_NAME NVARCHAR2(40) Nullable Loyalty item gift program name.
LTY_TOTAL_REDEEM_MULTIPLIER NUMBER(16,8) Nullable Multiplier for total-based redeem program
LTY_TOTAL_EARN_MULTIPLIER NUMBER(16,8) Nullable Multiplier for total-based earn program
LTY_ITEM_REDEEM_MULTIPLIER NUMBER(16,8) Nullable Multiplier for item-based redeem program
LTY_ITEM_EARN_MULTIPLIER NUMBER(16,8) Nullable Multiplier for item-based earn program
SALE_TRANS_DISC_AMT NUMBER(16,4) Nullable To track precise sale discount amounts without affecting total tax calculations. Note that this field is not spreadable, does not affect calculation of total tax or shipping amount and is independing from global discount amount. This field might be used by loyalty program.
ORDER_TRANS_DISC_AMT NUMBER(16,4) Nullable To track precise order discount amounts without affecting total tax calculations. Note that this field is not spreadable, does not affect calculation of total tax or shipping amount and is independing from global discount amount. This field might be used by loyalty program.
ORDER_TRANS_DISC_AMT_USED NUMBER(16,4) Nullable Amount of order transactional discount that has been recorded on sale.
LTY_ORDER_TOTAL_BASED_DISC NUMBER(16,4) Nullable The discount amount in base currency applied by the total-based program to the order part of the document.
LTY_SALE_EARNED_POINTS_P NUMBER(16,4) Nullable The total of positive points earned on the sale part of the document either from the item-based or total-based program.
LTY_SALE_EARNED_POINTS_N NUMBER(16,4) Nullable The total of negative points earned on the sale part of the document either from the item-based or total-based program.
LTY_ORDER_EARNED_POINTS_P NUMBER(16,4) Nullable The total of positive points earned on the order part of the document either from the item-based or total-based program.
LTY_ORDER_EARNED_POINTS_N NUMBER(16,4) Nullable The total of negative points earned on the order part of the document either from the item-based or total-based program.
LTY_SALE_USED_POINTS_P NUMBER(16,4) Nullable The total of positive points used to redeem items or applied to total-based redeem program on the sale part of the document.
LTY_SALE_USED_POINTS_N NUMBER(16,4) Nullable The total of negative points used to redeem items or applied to total-based redeem program on the sale part of the document.
LTY_ORDER_USED_POINTS_P NUMBER(16,4) Nullable The total of positive points used to redeem items or applied to total-based redeem program on the order part of the document.
LTY_ORDER_USED_POINTS_N NUMBER(16,4) Nullable The total of negative points used to redeem items or applied to total-based redeem program on the order part of the document.
FEE_AMT_RETURNED1 NUMBER(16,4) Nullable Returned fee amount.
SHIPPING_AMT_MANUAL_RETURNED NUMBER(16,4) Nullable Returned shipping amount (document level).
REF_SALE_SID NUMBER(19) Nullable Referenced sale document identifier (to return fees and shipping).
GIFT_RECEIPT_TYPE NVARCHAR2(40) Nullable Gif receipt preferences.
ORDER_DUE_DATE DATE Nullable Due date for sales order.
EXTERNAL_TRANSFER_STATUS NVARCHAR2(255) Nullable Only for external apps usage for tracking data transfer status.
DETAX_FLAG_MANUALLY NUMBER(1) Nullable Indicates detax was set manually.
AR_FLAG NUMBER(1) Nullable Sent to AR flag.
GL_FLAG NUMBER(1) Nullable Sent to GL flag.
AL_EXTRACT_DATE DATE Nullable Accounting Link extract date.
AL_POST_DATE DATE Nullable Accounting Link post date.
SHIP_DATE DATE Nullable The date after which order items can no longer be fulfilled.
ORDERED_DATE DATE Nullable The date that is reported as the ordered date for order items.
CANCEL_DATE DATE Nullable Cancel date.

DOCUMENT_COUPON

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

DOCUMENT_DEPOSIT

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

DOCUMENT_DISC

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

DOCUMENT_EXTEND

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

DOCUMENT_FEE_TYPE

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

DOCUMENT_ITEM

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

DOCUMENT_ITEM_DISC

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
DOC_ITEM_SID NUMBER(19) No Identifies the document item.
SPREAD_DOC_DISC_SID NUMBER(19) Yes Identifies the discount that was spread.
SPREAD NUMBER(1) No 0=native item discount, 1=from global discount
DISC_SOURCE NUMBER(5) No 0=Price Level, 1=Quantity Pricing, 2=Customer discount, 30=Manual discount, 40=promotion, 50=package.
DISC_POS NUMBER(5) No Position among similar discounts.
DISC_TYPE NUMBER(5) No 0=price, 1=discount percentage, 3=force price
DISC_VALUE NUMBER(5) No Discount value.
LOCK_TYPE NUMBER(16,4) No 0=not locked, 1=locked for fulfilling item, 2=locked for return item.
DISC_REASON NUMBER(5) Yes Discount reason.
PREV_PRICE NVARCHAR2(80) No previous price.
NEW_PRICE NUMBER(16,4) Yes New price.
NEW_DISC_AMT NUMBER(16,4) Yes New unit discount.
NEW_DISC_PERC NUMBER(16,4) Yes New discount percentage.
NEW_TAX_PERC NUMBER(16,4) Yes New tax percentage
DISC_PROMO_NAME NVARCHAR2(50) Yes pcp promotion name
DISC_PROMO_GROUP NVARCHAR2(50) Yes pcp promotion group
TMP_DATA NVARCHAR2(50) Yes Temporary data storage.
DISC_ORIG_VALUE NUMBER(16,4) No Uncapped value originally entered.

DOCUMENT_SEQUENCE

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
SBS_SID NUMBER(19) No Identifies the subsidiary.
DOC_SEQ_TYPE NUMBER(5) No Document type.
NEXT_VALUE NUMBER(10) Yes Next available value for the document number.

DOCUMENT_SEQUENCE_WKS

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
WS_SID NUMBER(19) No Identifies the workstation.
DOC_SEQ_TYPE NUMBER(5) No Document type
NEXT_VALUE NUMBER(10) Yes Next available value for the document number.

DOCUMENT_TAX_BREAK

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
DOC_SID NUMBER(19) No Unique system identifier for the document.
TAX_AREA NVARCHAR2(11) Yes Tax Area name.
TAX_CODE NVARCHAR2(5) Yes Tax Code name.
TAX_PERC NUMBER(16,4) Yes Tax rate (percentage)
TAX_AMT NUMBER(17,5) Yes Tax amount.
TAX_NAME NVARCHAR2(12) Yes Tax Rule name.

DOC_POS_FLAG

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
SBS_SID NUMBER(19)   The subsidiary to which this POS flag belongs.
NAME NVARCHAR2(15) Yes Name of the POS Flag
IS_REQUIRED NUMBER(1) No Required? 0=No, 1=Yes
FLAG_NO NUMBER(5) No Flag Numbers. 1=POS flag 1, 2=POS flag 2, 3=POS flag 3

DOC_POS_FLAG_OPTION

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
DOC_POS_FLAG_SID NUMBER(19) No Identifies the POS flag this option belongs to.
FLAG_OPTION NVARCHAR2(20) Yes User-defined option for that given flag.
IS_ACTIVE NUMBER(1) No If this option is active or not. 0=not active, 1=active. Default=0
FLAG_ID NUMBER(5) No Identifies the flag.

DRAWER

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

DRAWER_EVENT

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

DRAWER_EVENT_CURRENCY

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

EMAIL_TYPE

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

EMPLOYEE

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

EMPLOYEE_CHECK_IN_OUT

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
       
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

EMPLOYEE_EXTEND

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

EMPLOYEE_STORE

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

EMPLOYEE_SUBSIDIARY

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

EMPLOYEE_UDF

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

EMPLOYEE_UDF_OPTION

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

EXCHANGE_RATE

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

EXTERNAL_SERVICE

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

FISCAL_DOCUMENT

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       

FISCAL_DOCUMENT_ITEM

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

GRID_COLUMN

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

GRID_DATA

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

GRID_DICTIONARY

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

GRID_SEARCH_BY

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

INITIALIZATION_STATUS_DETAIL

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
RESOURCE_NAME NVARCHAR2(50) No Name of the resource that is currently being processed.
RESOURCE_ROWS_PROCESSED_SOFAR NUMBER(30) Yes Total rows processed so far for this resource.
LAST_UPDATE_DATETIME TIMESTAMP(0) WITH TIMEZONE Yes Date andtime this record was last updated.
HEADER_SID NUMBER(19) No Link to the initialization_status_header associated with this detail record.
TOTAL_ROWS_EXPECTED NUMBER(30) Yes Total records expected for this resource.
PROCESS_ORDER NUMBER(5) No The position in the process order for this resource. Default=0

INITIALIZATION_STATUS_HEADER

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
LOAD_STARTTIME TIMESTAMP(0) WITH TIME ZONE Yes Time when the initialization was started.
CURRENT_RESOURCE_WIP NVARCHAR2(50) Yes Name of the resource that is currently being processed.
TOTAL_ROWS_PROCESSED_SOFAR NUMBER(30) Yes Total number of rows processed for all resources so far.
LAST_UPDATE_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date and time this record was last updated.
COMPLETE_FLAG NUMBER(1) Yes 0=initialization load not complete, 1=initialization load complete.
TOTAL_ROWS_EXPECTED NUMBER(30) Yes Total number of rows expected for all resources for this initialization session.
REM_SUBSCRIPTION_SID NUMBER(19) No Link to subscription used for this initialization.
CURRENT_RESOURCE_SID NUMBER(19) Yes Identifies the current resource being processed.
CURRENT_PROCESS_ORDER NUMBER(10) Yes Identifies the current resource's position in the process order.
RESUME_COUNT NUMBER(5) Yes Number of times initialization has been resumed.

INIT_STATUS_CONNECTION

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
HEADER_SID NUMBER(19) No Link to initialization status header record.
REMOTE_CONNECTION_SID NUMBER(19) No Link to remote connection.
TOTAL_PROCESSED NUMBER(30) Yes Total records received and processed by the receiver.
TOTAL_FAILED NUMBER(30) Yes Of the total processed, the number that have failed on the receiver.
STATUS NUMBER(1) Yes Status of connection. 0=cancelled, 1=in progress, 2=complete.
       

INVN_ITEM_IMAGE

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

INVN_MEDIA

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

INVN_SBS_EXTEND

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

INVN_SBS_ITEM

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
INVN_ITEM_UID      
SBS_SID      
ALU      
STYLE_SID      
DCS_SID      
VEND_SID      
DESCRIPTION1      
DESCRIPTION2      
DESCRIPTION3      
DESCRIPTION4      
ATTRIBUTE      
COST      
SPIF      
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
LTY_PRICE_IN_POINTS NUMBER(24,8)   Loyalty price in points.
LTY_POINTS_EARNED NUMBER(24,8)   Loyalty points earned.
ITEM_STATE NUMBER(5)   Item state.
PUBLISH_STATUS NUMBER(1)    
MIN_ORD_QTY NUMBER(10,3)   Minimum order quantity.
       
VENDOR_LIST_COST NUMBER(16,4)   Vendor list cost.
TRADE_DISC_PERC NUMBER(16,4)   Trade discount percentage.
LONG_DESCRIPTION NVARCHAR2(2000)   Optional longer text description.
TEXT1 NVARCHAR2(255) Yes Text field
TEXT2 NVARCHAR2(255) Yes Text field
TEXT3 NVARCHAR2(255) Yes Text field
TEXT4 NVARCHAR2(255) Yes Text field
TEXT5 NVARCHAR2(255) Yes Text field
TEXT6 NVARCHAR2(255) Yes Text field
TEXT7 NVARCHAR2(255) Yes Text field
TEXT8 NVARCHAR2(255) Yes Text field
TEXT9 NVARCHAR2(255) Yes Text field
TEXT10 NVARCHAR2(255) Yes Text field
HEIGHT NUMBER(7,2) Yes Used to record shipping dimensions for an item.
LENGTH NUMBER(7,2) Yes Used to record shipping dimensions for an item.
WIDTH NUMBER(7,2) Yes Used to record shipping dimensions for an item.
SPECIAL_ORDER NUMBER(1) Yes Special order item. None or 0=no, 1=yes. Default=0
EXTERNAL_TRANSFER_STATUS NVARCHAR2(255) Yes Only for external apps usage for tracking data transfer status

INVN_SBS_ITEM_LOT

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

INVN_SBS_ITEM_LOT_QTY

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

INVN_SBS_ITEM_LTY

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

INVN_SBS_ITEM_QTY

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

INVN_SBS_ITEM_SN

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

INVN_SBS_ITEM_SN_QTY

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

 

INVN_SBS_KIT

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

INVN_SBS_PRICE

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

INVN_SBS_PRICE_HIST

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

INVN_SBS_SUBLOCATION_QTY

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

INVN_SBS_VENDOR

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

INVN_SERIAL

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

INVN_STYLE

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

INVN_STYLE

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

INVN_UDF

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

INVN_UDF_OPTION

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

JOB

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

KIT_COMPONENT

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

LIC_AUDIT

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

LICENSING

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

LICSECALLOCATION

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

LIC_SECONDARY

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

LOCATION

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

LTY_CUST_CENTRAL

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

LTY_CUST_LVL_HIST

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

LTY_CUST_PGM_GIVEN

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

LTY_CUST_POINTS_HIST

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

LTY_CUST_REWARD_HIST

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

LTY_LEVEL

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.
       
       
       
       
       
       

LTY_LEVEL_PROGRAM

Column Name Type Nullable? Notes
SID NUMBER(19) No Unique identifying value.
CREATED_BY NVARCHAR2(30) No Employee ID of employee who created the record.
CREATED_DATETIME TIMESTAMP(0) WITH TIME ZONE No Date/time the record was created.
MODIFIED_BY NVARCHAR2(30) Yes Employee ID of employee who last modified the record.
MODIFIED_DATETIME TIMESTAMP(0) WITH TIME ZONE Yes Date/time the record was last modified.
CONTROLLER_SID NUMBER(19) No Reference to store record for database that owns the row.
ORIGIN_APPLICATION NVARCHAR2(20) No Indicates application used to create row. v9 and v8 are reserved for Retail Pro versions 8 and 9. This is the same value that will be used in licensing applications.
POST_DATE DATE Yes Date and time the row was created/last modified in this system. May not be the same as CREATED_DATETIME and MODIFIEDBY_DATETIME
ROW_VERSION NUMBER(10) No Optimistic locking value. Default=1
TENANT_SID NUMBER(19) Yes Reference to tenant desription.