Diagrams


Table

Inventory Setup

Fields

# Name Type
1 Primary Key (Primary Key) Code10
2 Automatic Cost Posting (Automatic Cost Posting) Boolean
3 Location Mandatory (Location Mandatory) Boolean
4 Item Nos. (Item Nos.) Code20
30 Automatic Cost Adjustment (Automatic Cost Adjustment) Option
40 Prevent Negative Inventory (Prevent Negative Inventory) Boolean
5700 Transfer Order Nos. (Transfer Order Nos.) Code20
5701 Posted Transfer Shpt. Nos. (Posted Transfer Shpt. Nos.) Code20
5702 Posted Transfer Rcpt. Nos. (Posted Transfer Rcpt. Nos.) Code20
5703 Copy Comments Order to Shpt. (Copy Comments Order to Shpt.) Boolean
5704 Copy Comments Order to Rcpt. (Copy Comments Order to Rcpt.) Boolean
5718 Nonstock Item Nos. (Nonstock Item Nos.) Code20
5790 Outbound Whse. Handling Time (Outbound Whse. Handling Time) DateFormula
5791 Inbound Whse. Handling Time (Inbound Whse. Handling Time) DateFormula
5800 Expected Cost Posting to G/L (Expected Cost Posting to G/L) Boolean
5801 Default Costing Method (Default Costing Method) Option
5804 Average Cost Calc. Type (Average Cost Calc. Type) Option NotBlank: Yes
5805 Average Cost Period (Average Cost Period) Option NotBlank: Yes
7101 Item Group Dimension Code (Item Group Dimension Code) Code20
7300 Inventory Put-away Nos. (Inventory Put-away Nos.) Code20
7301 Inventory Pick Nos. (Inventory Pick Nos.) Code20
7302 Posted Invt. Put-away Nos. (Posted Invt. Put-away Nos.) Code20
7303 Posted Invt. Pick Nos. (Posted Invt. Pick Nos.) Code20
7304 Inventory Movement Nos. (Inventory Movement Nos.) Code20
7305 Registered Invt. Movement Nos. (Registered Invt. Movement Nos.) Code20
7306 Internal Movement Nos. (Internal Movement Nos.) Code20

Keys

# Fields
0 Primary Key (Primary Key) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Item Group Dimension Code (Item Group Dimension Code) Dimension Code (Code) 1..n
Internal Movement Nos. (Internal Movement Nos.) No. Series Code (Code) 1..n

Table Relations From Other Tables

From Table From Field