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.) Code10
30 Automatic Cost Adjustment (Automatic Cost Adjustment) Option
40 Prevent Negative Inventory (Prevent Negative Inventory) Boolean
5700 Transfer Order Nos. (Transfer Order Nos.) Code10
5701 Posted Transfer Shpt. Nos. (Posted Transfer Shpt. Nos.) Code10
5702 Posted Transfer Rcpt. Nos. (Posted Transfer Rcpt. Nos.) Code10
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.) Code10
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
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.) Code10
7301 Inventory Pick Nos. (Inventory Pick Nos.) Code10
7302 Posted Invt. Put-away Nos. (Posted Invt. Put-away Nos.) Code10
7303 Posted Invt. Pick Nos. (Posted Invt. Pick Nos.) Code10
7304 Inventory Movement Nos. (Inventory Movement Nos.) Code10
7305 Registered Invt. Movement Nos. (Registered Invt. Movement Nos.) Code10
7306 Internal Movement Nos. (Internal Movement Nos.) Code10

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