Dictionary Items Commonly Used in Reports

The dictionary items included in this topic are commonly used when creating reports.

Common ENTITY File Dictionary Items

The following ENTITY file dictionary items are commonly used when creating reports.

Attribute #	Dictionary ID	Notes
1	NAME
2	ADDRESS	Multi-valued
3	CITY
4	STATE
5	ZIP_CODE
8	SORT_BY
9	INDEX	Multi-valued
13	CLASS	Branch-specific
14	SHIP_TOS
16	CONTACTS	Multi-valued
17	PHONE_NBRS	Multi-valued
22	CREDIT_LIMIT
28	CUST_TERMS
34	TAX_EXP_NBR	Multi-valued
35	PRICING_TYPE
36	TAX_JUR_OVERRIDE
41	OUTSIDE_SALES
42	PRICE_STYLE
43	BACK_ORDER_STATUS
45	PO_NUM_REQ
46	SHIP_VIA
47	PAYMENT_DAYS
48	START_DATE
50	INVOICE_PRINT_COPIES
51	INVOICE_SELECT_CODE
53	HOME_BR
58	VENDOR_TERMS
60	OVER_SHORT_PERCENT
61	OVER_SHORT_DOLLAR
62	VENDOR_BACK_ORDER
77	SIC_CODE
78	CUSTOMER_SELECT_CODE
81	RANK
102	1099_TAX_ID

Common PRODUCT File Dictionary Items

The following PRODUCT file dictionary items are commonly used when creating reports.

Attribute #	Dictionary ID	Notes
1	DESC	Multi-valued
2	GL_PRODUCT_TYPE
3	STATUS
4	KEYWORDS	Multi-valued
9	PRICE_LINE
10	UNIT_WEIGHT
12	BUY_LINE
14	COMMODITY_CODE
19	SELECT_GROUP
35	PER_QTY	Branch-specific
63	PU_IDS

Common AR File Dictionary Items

The following AR file dictionary items are commonly used when creating reports.

Attribute #	Dictionary ID	Notes
1	PO_NBR
1	INV_NBR
8	BALANCE_DUE
10	BILL_TO_CUST_ID	Entity ID
11	DISCOUNT_DATE
12	DUE_DATE
13	SHIP_DATE
15	SHIP_TO_CUST_ID

Common PSUB File Dictionary Items

The following PSUB file dictionary items are commonly used when creating reports.

Attribute #	Dictionary ID	Notes
0	PSUB_ID	PSUB File ID = Product ID ~ GL Branch ~ GL Date ~ Ledger ID # ~ Generation # ~ Line Item # ~ Location Type ~ Bin Location or Direct Vendor ID ~ Kit Component ID ~ Shipping Branch, if different from GL Branch
1	QTY	Positive
4	DOLLAR_ENTITY_ID
5	PRODUCT_ENTITY_ID

Common MATRIX File Dictionary Items

The following MATRIX file dictionary items are commonly used when creating reports.

Attribute #	Dictionary ID
1	MATRIX_TYPE
3	PRICE_DATE_OVRD
4	BEST_PRICE
7	QTY_BREAK_BASIS
8	QTY_BREAK_FORMULA
12	COST_BASIS
13	COST_FORMULA
21	REBATE_DATA

Common ORDER.QUEUE File Dictionary Items

The following ORDER.QUEUE file dictionary items are commonly used when creating reports.

Attribute #	Dictionary ID	Notes
1	ORDER_STATUS	B, O, C, A, L, etc.
2	PRICE_BR
3	PRODUCT_BR
7	DOLLAR_ENTITY_ID
8	PRODUCT_ENTITY_ID
9	WRITER
11	SALESPERSON_OUT

Common PRINT.QUEUE File Dictionary Items

The following PRINT.QUEUE file dictionary items are commonly used when creating reports.

Attribute #	Dictionary ID	Notes
1	STATUS	I = Invoice
2	BR	Price Branch
3	STK.BR	Ship Branch
4	SHIPDATE	Invoice Date
5	PRT.STATUS	Q, P, B
6	BT.ENTITY
7	ST.ENTITY