POS Technical Documents

Microsoft RMS Database Field Values

SUMMARY

This article describes the values of various enumerated fields in a Store Operations database.

MORE INFORMATION

This list is of the most common enumerated fields in a Store Operations database. The format of the variables is TableName.ColumnName.

AccountReceivable.Type
0: Transaction Charge/Sale
1: Finance Charge
2: Debit/Credit Adjustment

AccountReceivableHistory.HistoryType
0: Charge/Sale
1: Return
2: Payment
3: Transfer
4: Refund
5: Adjustment
6: HQ Adjustment
7: Remote Payment

AccountType.DateDueType
1: Due After Close Billing Cycle Plus X Days
2: Due After Invoice Date Plus X Days

DailySales.Type

1: Supplier
2: Category
3: Department
4: Register
5: Cashier
6: Sales Rep

InventoryTransferLog.Type
1: Purchase Order
2: Transfer Offline From a Return
3: Transfer Offline From a Purchase Order
4: Manual Transfer Offline
5: Manual Quantity Adjustment
6: Inventory Wizard Quantity Adjustment
7: Physical Inventory Quantity Adjustment
8: HQ Quantity Adjustment
9: Parent Child Quantity Adjustment
10: Kit Component Transfer
11: HQ Manual Adjustment

Item.ItemType
0: Standard
1: Serialized
2: Matrix
3: Kit
4: Lot Matrix
5: Gasoline
6: Weighed
7: Non Inventory
8: Assembly
9: Voucher

ItemClass.ClassType
0: Matrix
1: Assembly
2: Lot Matrix

Journal.TranasctionType
1: Sale
2: Work Order
3: Quote
4: Back Order
5: Layaway
11: Drop
12: Payout
13: No Sale
14: Aborted Transaction
15: Account Payment
16: X Report
17: Z Report
18: ZZ Report
19: Blind Close
20. Account Adjustment
21: Finance Charge

Order.Type
2: Work Order
3: Quote
4: Back Order
5: Layaway

PhysicalInventory.Status
0: Open
1: Calculated
2: Closed

PurchaseOrder.POType
0: Local Purchase Order
1: HQ Purchase Order
2: Local Transfer In
3: Local Transfer Out
4: HQ Transfer In
5: HQ Transfer Out

PurchaseOrder.Status
0: Open
1: Back Ordered (Partial)
2: Closed

Tender.AdditionalDetailType
0: Other
1: Cash
2: Check
3: Credit Card
4: Account
5: Not used
6: Food Stamp
7: EC Cash Card
8: Voucher
9: Debit Card

TransactionEntry.PriceSource
1: Retail Price
2: Quantity Discount
3: Buydown Price
4: Level Price
5: Sale Price
6: Cashier Discount From Retail
7: Cashier Discount From Current Price
8: Cashier Discount, Markup From Cost
9: Cashier Discount, Set Profit Margin
10: Cashier Discount, Set Price
11: Component Price
12: Price Level A
13: Price Level B
14: Price Level C
15: Discount From Retail
16: Discount From Current Price
17: Markup From Cost
18: Set Profit Margin

VisaNetAuthorization.Status
0: Open (authorized but not settled)
1: Voided
2: Settled
3: Connection Error
4: Header Error
5: Detail Error
6: Duplicate Batch