Back

Inventory (IN) - INPRODMM

Name Type Length Decimal Relation Description
PRODLINE String 4 IN PRODUCT LINE PRODLINE - The product line code
PRODDESC String 30 IN PRODUCT LINE PRODDESC - The product line description
ITEMTYPE String 1 IN ITEMTYPE
ITEMVAL String 1 IN ITEMVAL
PRICECODE String 4 IN PRICECODE
BACKORDERS Boolean 1 IN BACKORDERS
TAXABLE Boolean 1 IN TAXABLE
COMMISSION String 1 IN COMMISSION
UMSTAND String 4 IN UMSTAND
UMPURCH String 4 IN UMPURCH
UMSALES String 4 IN UMSALES
INVACCTNUM String 12 IN PRODUCT LINE INVACCTNUM - The inventory general ledger account for items in this product line
COSACCTNUM String 12 IN PRODUCT LINE COSACCTNUM - The cost of goods sold general ledger account for items in this product line
SIACCTNUM String 12 IN PRODUCT LINE SIACCTNUM - The sales /revenue general ledger account for items in this product line
RETACCTNUM String 12 IN PRODUCT LINE RETACCTNUM - The returns general ledger account for items in this product line
ADJACCTNUM String 12 IN PRODUCT LINE ADJACCTNUM - The adjustments general ledger account for items in this product line
PURACCTNUM String 12 IN PRODUCT LINE PURACCTNUM - The purchases general ledger account for items in this product line
VARACCTNUM String 12 IN PRODUCT LINE VARACCTNUM - The purchases variance general ledger account for items in this product line
DROPSHIP Boolean 1 IN DROPSHIP
PURCHFACT Decimal 12 4 IN PURCHFACT
SALESFACT Decimal 12 4 IN SALESFACT
COMMRATE Decimal 5 2 IN PRODUCT LINE COMMRATE - The commission rate if product line commissions are used.
INVCYCLE String 10 IN INVCYCLE
WIPACCTNUM String 12 IN WIPACCTNUM
SCPACCTNUM String 12 IN SCPACCTNUM
UMPROD String 4 IN UMPROD
PRODFACT Decimal 12 4 IN PRODFACT
OWACCTNUM String 12 IN OWACCTNUM
ITEM_FMT String 36 IN ITEM_FMT
ITEM_SEG Decimal 2 0 IN ITEM_SEG
SEG1_SIZE Decimal 2 0 IN SEG1_SIZE
SEG2_SIZE Decimal 2 0 IN SEG2_SIZE
SEG3_SIZE Decimal 2 0 IN SEG3_SIZE
SEG4_SIZE Decimal 2 0 IN SEG4_SIZE
SEG5_SIZE Decimal 2 0 IN SEG5_SIZE
SEG6_SIZE Decimal 2 0 IN SEG6_SIZE
SEG7_SIZE Decimal 2 0 IN SEG7_SIZE
SEG8_SIZE Decimal 2 0 IN SEG8_SIZE
SEG9_SIZE Decimal 2 0 IN SEG9_SIZE
SEG10_SIZE Decimal 2 0 IN SEG10_SIZE
SEG11_SIZE Decimal 2 0 IN SEG11_SIZE
SEG12_SIZE Decimal 2 0 IN SEG12_SIZE
SEG1_DESC String 10 IN SEG1_DESC
SEG2_DESC String 10 IN SEG2_DESC
SEG3_DESC String 10 IN SEG3_DESC
SEG4_DESC String 10 IN SEG4_DESC
SEG5_DESC String 10 IN SEG5_DESC
SEG6_DESC String 10 IN SEG6_DESC
SEG7_DESC String 10 IN SEG7_DESC
SEG8_DESC String 10 IN SEG8_DESC
SEG9_DESC String 10 IN SEG9_DESC
SEG10_DESC String 10 IN SEG10_DESC
SEG11_DESC String 10 IN SEG11_DESC
SEG12_DESC String 10 IN SEG12_DESC
VAR_SEG Decimal 2 0 IN VAR_SEG
SEG1_DS Decimal 2 0 IN SEG1_DS
SEG2_DS Decimal 2 0 IN SEG2_DS
SEG3_DS Decimal 2 0 IN SEG3_DS
SEG4_DS Decimal 2 0 IN SEG4_DS
SEG5_DS Decimal 2 0 IN SEG5_DS
SEG6_DS Decimal 2 0 IN SEG6_DS
SEG7_DS Decimal 2 0 IN SEG7_DS
SEG8_DS Decimal 2 0 IN SEG8_DS
SEG9_DS Decimal 2 0 IN SEG9_DS
SEG10_DS Decimal 2 0 IN SEG10_DS
SEG11_DS Decimal 2 0 IN SEG11_DS
SEG12_DS Decimal 2 0 IN SEG12_DS
DESC_FMT String 40 IN DESC_FMT
MULTIBIN Boolean 1 IN MULTIBIN
FRTVARACCT String 12 IN FRTVARACCT
FRTCLRACCT String 12 IN FRTCLRACCT
TAXCLASS String 2 IN TAXCLASS
DISCOUNT Boolean 1 IN DISCOUNT
COMPNO01 Int32 4 IN COMPNO01
COMPNO02 Int32 4 IN COMPNO02
COMPNO03 Int32 4 IN COMPNO03
COMPNO04 Int32 4 IN COMPNO04
COMPNO05 Int32 4 IN COMPNO05
COMPNO06 Int32 4 IN COMPNO06
COMPNO07 Int32 4 IN COMPNO07
COMPNO08 Int32 4 IN COMPNO08
COMPNO09 Int32 4 IN COMPNO09
COMPNO10 Int32 4 IN COMPNO10
COMPNO11 Int32 4 IN COMPNO11
COMPNO12 Int32 4 IN COMPNO12
AUTOBOM Boolean 1 IN AUTOBOM
ROYALTYEXP String 12 IN ROYALTYEXP
MISCLRACCT String 12 IN MISCLRACCT
BRKCLRACCT String 12 IN BRKCLRACCT
STDREVACCT String 12 IN STDREVACCT
STDFRTREV String 12 IN STDFRTREV
CUSCLRACCT String 12 IN CUSCLRACCT