What's in this page?
Supported Tables
Supported Fields and Special Rules
TABLE: HOME_COUNTRY_STORAGE
Fields that Will Be Populated but Not Imported
Fields that Will Not Be Imported
TABLE: SERVICE_ORDER
Supported Tables
HOME_COUNTRY_STORAGE
HOME_COUNTRY_STORAGE_CF
SERVICE_ORDER
The above tables have unsupported fields. See Supported Fields and Special Rules for a list of unsupported fields.
Supported Fields and Special Rules
The following table contains details about every field/column in the tables available to the import file.
TABLE: HOME_COUNTRY_STORAGE
Supported Fields
Field Mapping
|
Format
|
Length
|
Req'd
|
Field Rule(s)
|
AUTHORIZATION_DATE
|
Date
|
8
|
|
|
AUTHORIZED_WEIGHT
|
Number
|
12
|
|
|
AUTHORIZED_WEIGHT_UNITS
|
Text
|
50
|
|
Supply the value in the DISPLAY_VALUE column of the CLASSIFICATION table for group code EQWTMS
|
PACKING_DATE
|
Date
|
8
|
|
|
DELIVERED_TO_STORAGE_DATE
|
Date
|
8
|
|
|
REMOVED_FROM_STORAGE_DATE
|
Date
|
8
|
|
|
DELIVERY_DATE
|
Date
|
8
|
|
|
SPECIAL_SERVICES_AUTHORIZED
|
Text
|
255
|
|
|
INSURANCE_TYPE
|
Text
|
50
|
|
Supply the value in the DISPLAY_VALUE column of the CLASSIFICATION table for group code EQSTIN
|
INSURANCE_BASIS
|
Text
|
50
|
|
Supply the value in the DISPLAY_VALUE column of the CLASSIFICATION table for group code EQINBS
|
PAYMENT_SCHEDULE
|
Text
|
50
|
|
Supply the value in the DISPLAY_VALUE column of the CLASSIFICATION table for group code EQTMFM
|
STORAGE_DAMAGES
|
Text
|
50
|
|
Supply the value in the DISPLAY_VALUE column of the CLASSIFICATION table for group code EQBOOL
|
CLAIM_AMOUNT
|
Number
|
9.2
|
|
|
CLAIM_CURRENCY
|
Text
|
3
|
|
Needs to be a GROW 3-digit currency code. Matches to the CODE column of the CURRENCY table.
|
CLAIM_DATE
|
Date
|
8
|
|
|
CLAIM_TEXT
|
Text
|
255
|
|
|
SETTLEMENT_AMOUNT
|
Number
|
9.2
|
|
|
SETTLEMENT_CURRENCY
|
Text
|
3
|
|
Needs to be a GROW 3-digit currency code. Matches to the CODE column of the CURRENCY table.
|
SETTLEMENT_DATE
|
Date
|
8
|
|
|
Fields that Will Be Populated but Not Imported
Field Mapping
|
Format
|
Length
|
Req'd
|
Field Rule(s)
|
ID
|
Integer
|
4
|
YES
|
|
ASSIGNMENT_ID
|
Integer
|
4
|
YES
|
|
SERVICE_ORDER_ID
|
Integer
|
4
|
NO
|
|
CREATE_DATE
|
Date
|
8
|
YES
|
|
CREATE_BY
|
Text
|
50
|
NO
|
|
LAST_UPDATE_DATE
|
Date
|
8
|
NO
|
|
LAST_UPDATE_BY
|
Text
|
50
|
NO
|
|
Fields that Will Not Be Imported
Field Mapping
|
Format
|
Length
|
Req'd
|
Field Rule(s)
|
LOCKED
|
|
|
|
|
LOCKED_SOURCE
|
|
|
|
|
LOCKED_DATE
|
|
|
|
|
LOCKED_BY
|
|
|
|
|
TABLE: SERVICE_ORDER
Supported Fields
Field Mapping
|
Format
|
Length
|
Req'd
|
Field Rule(s)
|
TYPE
|
Text
|
50
|
YES
|
Supply the value in the DISPLAY_VALUE column of the CLASSIFICATION table for group code EQVSRV
|
VENDOR_ID
|
Text
|
100
|
|
Supply the value in the SYSTEM_NUMBER column of the VENDOR table
|
VENDOR_CONTACT_ID
|
Number
|
9
|
|
Supply the value in the ID column of the VENDOR_CONTACT table
|
SERVICE_COORDINATOR_RESOURCE_ID
|
Number
|
9
|
|
Supply the value in the ID column of the RESOURCE table
|
DUE_DATE
|
Date
|
8
|
|
|
SERVICE_COMPLETE_DATE
|
Date
|
8
|
|
|
PAYMENT_COMPLETE_DATE
|
Date
|
8
|
|
|
APPROVED
|
Text
|
50
|
|
Supply the value in the DISPLAY_VALUE column of the CLASSIFICATION table for group code EQBOOL
|
APPROVED_BY
|
Text
|
50
|
|
|
Fields that Will Be Populated but Not Imported
Field Mapping
|
Format
|
Length
|
Req'd
|
Field Rule(s)
|
ID
|
Integer
|
4
|
Y
|
|
ASSIGNMENT_ID
|
Integer
|
4
|
Y
|
|
CREATE_DATE
|
Date
|
8
|
N
|
|
CREATE_BY
|
Text
|
50
|
N
|
|
LAST_UPDATE_DATE
|
Date
|
8
|
N
|
|
LAST_UPDATE_BY
|
Text
|
50
|
N
|
|
Fields that Will Not Be Imported
Field Mapping
|
Format
|
Length
|
Req'd
|
Field Rule(s)
|
SUMMARY
|
|
|
|
|
STATUS
|
|
|
|
|
SOURCE_ID
|
|
|
|
|
SOURCE_SYSTEM
|
|
|
|
|
SOURCE_SYSTEM_TEXT_KEY
|
|
|
|
|
SERVICE_AGENT_ID
|
|
|
|
|
ESTIMATE_DUE_DATE
|
|
|
|
|
ESTIMATE_AMOUNT
|
|
|
|
|
ESTIMATE_CURRENCY
|
|
|
|
|
ESTIMATE_RECEIVED_DATE
|
|
|
|
|
PURCHASE_ORDER_NUMBER
|
|
|
|
|