NameDescriptionTypeAdditional information
PARTNUMBER

string

None.

SUBP

string

None.

LOGNO

integer

None.

DOS_LOGNO

integer

None.

DOS_FROM_LOGNO

integer

None.

DOS_FROM_TO

string

None.

DOS_CONVERTED

string

None.

PART_SSN

integer

None.

SERIAL_NO

string

None.

WHCODE

string

None.

LOCATION

string

None.

LOT_WHCODE

string

None.

CUSTOMS_WHCODE

string

None.

PART_LOCATION

string

None.

MFG

string

None.

MFG_SUBC

string

None.

MFG_DATE

date

None.

WARRANTY

date

None.

SHELF_LIFE

integer

None.

GOOD_TILL

date

None.

LAST_CUSTOM_TC_1

date

None.

SOURCE

string

None.

SUBS

string

None.

SOURCEDT

date

None.

REPAIREDBY

string

None.

SUBR

string

None.

REPAIREDT

date

None.

ORIGDOC_CATEGORY

string

None.

ORIGDOC_NO

integer

None.

ORIGDOC_LINE

decimal number

None.

RCVDOC_CATEGORY

string

None.

RCVDOC_NO

integer

None.

RCVDOC_LINE

decimal number

None.

COUNT_DATE

date

None.

COUNT_QTY

decimal number

None.

RESERVED

decimal number

None.

TRANSPORT

decimal number

None.

INHOUSE_QA

decimal number

None.

BOOKED

decimal number

None.

CONVERT_FROM

string

None.

CONVERT_LOGNO

integer

None.

REF1

string

None.

REF2

string

None.

REF3

string

None.

REF4

string

None.

REF5

string

None.

REF6

string

None.

REF7

string

None.

REF8

string

None.

REF9

string

None.

REF10

string

None.

REF11

string

None.

REF12

string

None.

REF13

date

None.

REF14

date

None.

REF15

date

None.

RCV_DATE

date

None.

QTY

decimal number

None.

COND

string

None.

QTY_INSTOCKUM

string

None.

QTY_INSTOCKREV

string

None.

CRNCY_CODE

string

None.

CURENCY_CONV

string

None.

CRNCY_FACTOR

decimal number

None.

CRNCY_DATE

date

None.

FIRSTCOST

decimal number

None.

FIRSTCOSTUM

string

None.

FIRSTCOSTTYPE

string

None.

MINIMUM_UNITP

decimal number

None.

MINIMUM_UNITP_CRNCY

string

None.

COST

decimal number

None.

COSTUM

string

None.

COST_CALCULATED

decimal number

None.

FORMULA

string

None.

GL_ACCOUNT

string

None.

COMPANYNO

integer

None.

DIVISION

string

None.

DEPART

string

None.

LINE_TYPE

string

None.

UNITP

decimal number

None.

UNITP1

decimal number

None.

UNITP2

decimal number

None.

UNITP3

decimal number

None.

COST_CAP

decimal number

None.

DIFF_COST

decimal number

None.

UNITP1_ADD

string

None.

UNITP2_ADD

string

None.

UNITP3_ADD

string

None.

COST_CAP_ADD

string

None.

SUBTOTAL

decimal number

None.

DISC_AMT

decimal number

None.

SUBTOTALNET

decimal number

None.

MISC1_AMT

decimal number

None.

MISC2_AMT

decimal number

None.

MISC3_AMT

decimal number

None.

MISC4_AMT

decimal number

None.

MISC5_AMT

decimal number

None.

MISC6_AMT

decimal number

None.

MISC1_ADD

string

None.

MISC2_ADD

string

None.

MISC3_ADD

string

None.

MISC4_ADD

string

None.

MISC5_ADD

string

None.

MISC6_ADD

string

None.

CERTIFICATE_CODE

string

None.

CERTIFICATE_NO

string

None.

MNT_CERTIFICATE_CODE

string

None.

MNT_CERTIFICATE_NO

string

None.

QUALITY_CODE

string

None.

MFG_CERTIFICATE_CODE

string

None.

ROHS_COMPLIANCE

string

None.

ORIG_PARTNUMBER

string

None.

ORIG_SUBP

string

None.

ORIG_LOGNO

integer

None.

COUNTRY

string

None.

WORK_PERFORMED

string

None.

NO_REPAIR_WAS_DONE

string

None.

CURE_DATE

date

None.

DOCNUMBER

string

None.

REV_NO

string

None.

GDP_FACTOR

decimal number

None.

GDP_EC

string

None.

GDP_FROM_DATE

date

None.

SUPPLIER_ACCOUNTNO

string

None.

SUPPLIER_SUBC

string

None.

INVENTORY_IMPORT_HIST_DOC_NO

integer

None.

STOCK_MOVEMENT_CODE

string

None.

STOCK_MOVEMENT_DATE

date

None.

RECLOCK

string

None.

ADDED_USR

string

None.

ADDED_DTE

date

None.

UPDATED_USR

string

None.

UPDATED_DTE

date

None.