QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
tblc_mstr
Table Change Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_tblc_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
tblc__qadc01
 
 
X(24)
 
 
tblc__qadc02
 
 
X(24)
 
 
tblc_active
Active
 
yes/no
 
 
tblc_delete
Delete
 
yes/no
 
 
tblc_desc
Description
 
x(24)
 
 
tblc_domain
Domain
 
x(8)
 
 
tblc_mod_date
Modified Date
Mod Date
99/99/99
 
 
tblc_mod_userid
User ID
 
X(24)
 
 
tblc_table
Table
 
x(16)
 
 
tblc_user1
User Field Character 1
 
X(24)
 
 
tblc_user2
User Field Character 2
 
X(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_tblc_mstr
yes
oid_tblc_mstr
yes
no
tblc_table
yes
tblc_domain
yes
no
 
 
 
tblc_table
yes
no
tbl_mstr
Service/Support Parent/Child Relationship Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_tbl_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
tbl__chr01
User Character Field 1
 
x(8)
 
 
tbl__chr02
User Character Field 2
 
x(8)
 
 
tbl__chr03
User Character Field 3
 
x(8)
 
 
tbl__chr04
User Character Field 4
 
x(8)
 
 
tbl__chr05
User Character Field 5
 
x(8)
 
 
tbl__dec01
User Decimal Field 1
 
->>,>>9.99
10
 
tbl__dec02
User Decimal Field 2
 
->>,>>9.99
10
 
tbl__dte01
User Date Field 1
 
99/99/99
 
 
tbl__dte02
User Date Field 2
 
99/99/99
 
 
tbl__log01
User Logical Field 1
 
yes/no
 
 
tbl__log02
User Logical Field 2
 
yes/no
 
 
tbl__qadc01
QAD Character Field 1
 
x(8)
 
 
tbl__qadc02
QAD Character Field 2
 
x(8)
 
 
tbl__qadd01
QAD Date Field 1
 
99/99/99
 
 
tbl__qadd02
QAD Date Field 2
 
99/99/99
 
 
tbl__qadde01
QAD Decimal Field 1
 
->>,>>9.99
10
 
tbl__qadde02
QAD Decimal Field 2
 
->>,>>9.99
10
 
tbl__qadl01
QAD Logical Field 1
 
yes/no
 
 
tbl__qadl02
QAD Logical Field 2
 
yes/no
 
 
tbl_compcode
Component
 
x(18)
 
 
tbl_comptype
Component Type
Comp Type
x(12)
 
 
tbl_domain
Domain
 
x(8)
 
 
tbl_end
End Effective
End Eff
99/99/99
 
 
tbl_mod_date
Modified Date
Mod Date
99/99/99
 
 
tbl_mod_userid
User ID
 
X(8)
 
 
tbl_parcode
Parent
 
x(18)
 
 
tbl_partype
Parent Type
 
x(12)
 
 
tbl_ref
Reference
 
x(12)
 
 
tbl_rmks
Remarks
 
x(24)
 
 
tbl_start
Start Effective
Start Eff
99/99/99
 
 
tbl_user1
Ufld1
 
x(8)
 
 
tbl_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_tbl_mstr
yes
oid_tbl_mstr
yes
no
 
tbl_comp
no
tbl_domain
yes
no
 
 
 
tbl_comptype
yes
no
 
 
 
tbl_compcode
yes
no
tbl_typecode
yes
tbl_domain
yes
no
 
 
 
tbl_partype
yes
no
 
 
 
tbl_parcode
yes
no
 
 
 
tbl_comptype
yes
no
 
 
 
tbl_compcode
yes
no
tbtx_mstr
Tax Balance Amounts
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_tbtx_mstr
Unique application generated record identifier.
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
tbtx__qadc01
 
 
x(24)
 
 
tbtx__qadc02
 
 
x(24)
 
 
tbtx__qadd01
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
tbtx__qadt01
 
 
99/99/99
 
 
tbtx_domain
Domain
 
x(8)
 
 
tbtx_entity
Entity code
 
x(20)
 
 
tbtx_mod_date
Last Modified Date
 
99/99/99
 
 
tbtx_mod_userid
Last Modified User Id
 
x(8)
 
 
tbtx_period
GL Period
 
99
 
 
tbtx_tax_amt
Tax Balance Amount
 
->,>>>,>>>,>>9.99
10
 
tbtx_tax_box_code
Tax box code
 
x(20)
 
 
tbtx_user1
User Field Character 1
 
x(24)
 
 
tbtx_user2
User Field Character 2
 
x(24)
 
 
tbtx_year
GL Year
 
9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_tbtx_mstr
yes
oid_tbtx_mstr
yes
no
tbtx_tax_box
yes
tbtx_domain
yes
no
 
 
 
tbtx_entity
yes
no
 
 
 
tbtx_year
yes
no
 
 
 
tbtx_period
yes
no
 
 
 
tbtx_tax_box_code
yes
no
TemplateD
Warehousing Printer Template Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
Language
Language
Lang
x(2)
 
 
ModDate
Modified Date
Mod Date
99/99/99
 
 
ModUserID
User ID
 
x(8)
 
 
oid_TemplateD
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
PrinterType
Printer Type
Printer!Type
X(8)
 
 
PrintFlavor
Print Flavor
Prt!Flv
x(1)
 
 
PrintLine
Print Line
 
x(132)
 
 
PrintProcCode
Print Procedure Code
Print!Proc
x(2)
 
 
PrintSeq
Seq
 
>>>9
 
 
QadC01
QAD Field
 
X(8)
0
 
QadC02
QAD Field
 
X(8)
0
 
QadC03
QAD Field
 
X(8)
0
 
QadC04
QAD Field
 
X(8)
0
 
QadC05
QAD Field
 
X(8)
0
 
QadD01
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD02
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadI01
QAD Field
 
->,>>>,>>9
 
 
QadI02
QAD Field
 
->,>>>,>>9
 
 
QadI03
QAD Field
 
->,>>>,>>9
 
 
QadL01
QAD Field
 
yes/no
 
 
QadL02
QAD Field
 
yes/no
 
 
QadT01
QAD Field
 
99/99/99
 
 
QadT02
QAD Field
 
99/99/99
 
 
QadT03
QAD Field
 
99/99/99
 
 
User1
User 1
 
x(8)
 
 
User2
User 2
 
x(8)
 
 
UserC03
User Field Character 3
 
x(24)
 
 
UserC04
User Field Character 4
 
x(24)
 
 
UserC05
User Field Character 5
 
x(24)
 
 
UserD01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserD02
User Field Decimal 2
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserI01
User Field Integer 1
 
->>>>>>>9
 
 
UserI02
User Field Integer 2
 
->>>>>>>9
 
 
UserL01
User Field Logical 1
 
yes/no
 
 
UserL02
User Field Logical 2
 
yes/no
 
 
UserT01
User Field Date 1
 
99/99/99
 
 
UserT02
User Field Date 1
 
99/99/99
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_TemplateD
yes
oid_TemplateD
yes
no
TempSeq
yes
Domain
yes
no
 
 
 
Language
yes
no
 
 
 
PrinterType
yes
no
 
 
 
PrintProcCode
yes
no
 
 
 
PrintFlavor
yes
no
 
 
 
PrintSeq
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
TemplateM
Warehousing Printer Template Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
CmtIndx
Comments
 
>>>>>>>9
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Description
Description
 
x(24)
 
 
Domain
Domain
 
x(8)
 
 
Language
Language
Lang
x(2)
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
oid_TemplateM
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
OrigFile
File
 
x(72)
 
 
PrinterType
Printer Type
Printer!Type
X(8)
 
 
PrintFlavor
Print Flavor
Prt!Flv
x(1)
 
 
PrintProcCode
Print Procedure Code
Print!Proc
x(2)
 
 
QadC01
QAD Field
 
X(8)
0
 
QadC02
QAD Field
 
X(8)
0
 
QadC03
QAD Field
 
X(8)
0
 
QadC04
QAD Field
 
X(8)
0
 
QadC05
QAD Field
 
X(8)
0
 
QadD01
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD02
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadI01
QAD Field
 
->,>>>,>>9
 
 
QadI02
QAD Field
 
->,>>>,>>9
 
 
QadI03
QAD Field
 
->,>>>,>>9
 
 
QadL01
QAD Field
 
yes/no
 
 
QadL02
QAD Field
 
yes/no
 
 
QadT01
QAD Field
 
99/99/99
 
 
QadT02
QAD Field
 
99/99/99
 
 
QadT03
QAD Field
 
99/99/99
 
 
User1
User 1
 
x(8)
 
 
User2
User 2
 
x(8)
 
 
UserC03
User Field Character 3
 
x(24)
 
 
UserC04
User Field Character 4
 
x(24)
 
 
UserC05
User Field Character 5
 
x(24)
 
 
UserD01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserD02
User Field Decimal 2
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserI01
User Field Integer 1
 
->>>>>>>9
 
 
UserI02
User Field Integer 2
 
->>>>>>>9
 
 
UserL01
User Field Logical 1
 
yes/no
 
 
UserL02
User Field Logical 2
 
yes/no
 
 
UserT01
User Field Date 1
 
99/99/99
 
 
UserT02
User Field Date 1
 
99/99/99
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_TemplateM
yes
oid_TemplateM
yes
no
Tempidx
yes
Domain
yes
no
 
 
 
Language
yes
no
 
 
 
PrinterType
yes
no
 
 
 
PrintProcCode
yes
no
 
 
 
PrintFlavor
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
te_mstr
Transaction Export Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_te_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
te__chr01
 
 
X(8)
 
 
te__chr02
 
 
X(8)
 
 
te__dec01
 
 
999999999.99
10
 
te__dec02
 
 
999999999.99
10
 
te__dte01
 
 
99/99/99
 
 
te__dte02
 
 
99/99/99
 
 
te__log01
 
 
yes/no
 
 
te__log02
 
 
yes/no
 
 
te__qadc01
 
 
X(8)
 
 
te__qadc02
 
 
X(8)
 
 
te__qadc03
 
 
X(8)
 
 
te__qadc04
 
 
X(8)
 
 
te__qadd07
 
 
999999999.99
10
 
te__qadd08
 
 
999999999.99
10
 
te__qadi05
 
 
9999
 
 
te__qadi06
 
 
9999
 
 
te__qadl11
 
 
YES/NO
 
 
te__qadl12
 
 
YES/NO
 
 
te__qadt09
 
 
99/99/99
 
 
te__qadt10
 
 
99/99/99
 
 
te_data
DATA
 
X(255)
 
 
te_date
Date Created
 
99/99/99
 
 
te_date_deliv
Date Delivered
 
99/99/99
 
 
te_date_exp
Date Exported
 
99/99/99
 
 
te_dest
Dest ID
 
x(16)
 
 
te_domain
Domain
 
x(8)
 
 
te_exp_type
Export Type
 
x(16)
 
 
te_line
Line
 
9999
 
 
te_nbr
Number
 
99999999
 
 
te_pgm
Program
 
x(16)
 
 
te_pgm_errs
Error Count
 
9999
 
 
te_pgm_msgs[10]
Errors
 
x(40)
 
 
te_pgm_warn
Warn Count
 
9999
 
 
te_site
Site
 
x(8)
 
 
te_time
Time Created
 
x(8)
 
 
te_time_deliv
Time Delivered
 
x(8)
 
 
te_time_exp
Time Exported
 
x(8)
 
 
te_updt
Update Type
 
x(3)
 
 
te_user1
Ufld1
 
X(8)
 
 
te_user2
Ufld2
 
X(8)
 
 
te_userid
User ID
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_te_mstr
yes
oid_te_mstr
yes
no
 
te_date
no
te_domain
yes
no
 
 
 
te_date
yes
no
 
te_date_deliv
no
te_domain
yes
no
 
 
 
te_date_deliv
yes
no
 
te_dest
no
te_domain
yes
no
 
 
 
te_dest
yes
no
 
te_exp_type
no
te_domain
yes
no
 
 
 
te_exp_type
yes
no
te_mstr
yes
te_domain
yes
no
 
 
 
te_site
yes
no
 
 
 
te_nbr
yes
no
 
 
 
te_line
yes
no
 
te_nbr
yes
te_domain
yes
no
 
 
 
te_nbr
yes
no
 
 
 
te_line
yes
no
tm_mstr
Transportation Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_tm_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
tm__qadc01
 
 
x(8)
 
 
tm_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
tm_code
Transport ID
Trans ID
x(8)
 
 
tm_cube_um
UM
 
x(2)
 
 
tm_desc
Description
 
x(24)
 
 
tm_domain
Domain
 
x(8)
 
 
tm_gross_wt
Gross Vehicle Weight
GVW
->>,>>>,>>9.9<<<
10
 
tm_height
Height
 
>>>,>>>,>>9.9<<<
10
 
tm_length
Length
 
>>>,>>>,>>9.9<<<
10
 
tm_load_lt
Load LT
 
->>9.9<
10
 
tm_maxcube
Max Load Volume
Max Vol
>>>,>>>,>>9.9<<<
10
 
tm_maxweight
Max Load Weight
Max Load
>>>,>>>,>>9.9<<<
10
 
tm_no_units
Available Units
Units
->,>>>,>>9
 
 
tm_pallet_floor_locations
Pallet Floor Locations
 
>>9
 
 
tm_pallets
Pallet Capacity
Pallets
>>>,>>>,>>9
 
 
tm_rate_code
Rate Table
Rate
x(8)
 
 
tm_stack_level
Stacking Level
 
>>9
 
 
tm_type
Transport Type
Type
x(8)
 
 
tm_unload_lt
Unload LT
 
->>9.9<
10
 
tm_user1
Ufld1
 
x(8)
 
 
tm_user2
Ufld2
 
x(8)
 
 
tm_weight_um
UM
 
x(2)
 
 
tm_width
Width
 
>>>,>>>,>>9.9<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_tm_mstr
yes
oid_tm_mstr
yes
no
tm_code
yes
tm_domain
yes
no
 
 
 
tm_code
yes
no
 
tm_desc
no
tm_domain
yes
no
 
 
 
tm_desc
yes
no
 
 
 
tm_code
yes
no
 
tm_rate
no
tm_domain
yes
no
 
 
 
tm_rate_code
yes
no
 
 
 
tm_code
yes
no
totd_det
Terms of Trade Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_totd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
totd__qadc01
 
 
x(24)
 
 
totd__qadc02
 
 
x(24)
 
 
totd_domain
Domain
 
x(8)
 
 
totd_lc_charge
Logistics Charge Code
Chrg Code
x(8)
 
 
totd_mod_date
Modified Date
Mod Date
99/99/99
 
 
totd_mod_userid
User ID
 
x(8)
 
 
totd_responsibility
Responsibility
 
x(2)
 
 
totd_terms_code
Terms of Trade
 
x(8)
 
 
totd_user1
User Field Character 1
 
x(24)
 
 
totd_user2
User Field Character 2
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_totd_det
yes
oid_totd_det
yes
no
totd_terms_code
yes
totd_domain
yes
no
 
 
 
totd_terms_code
yes
no
 
 
 
totd_lc_charge
yes
no
tot_mstr
Terms of Trade Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_tot_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
tot__qadc01
 
 
x(24)
 
 
tot__qadc02
 
 
x(24)
 
 
tot_domain
Domain
 
x(8)
 
 
tot_mod_date
Modified Date
Mod Date
99/99/99
 
 
tot_mod_userid
User ID
 
x(8)
 
 
tot_terms_code
Terms of Trade
 
x(8)
 
 
tot_terms_desc
Description
 
x(24)
 
 
tot_transport_resp
Transportation Responsibility
 
x(2)
 
 
tot_user1
User Field Character 1
 
x(24)
 
 
tot_user2
User Field Character 2
 
x(24)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_tot_mstr
yes
oid_tot_mstr
yes
no
tot_terms_code
yes
tot_domain
yes
no
 
 
 
tot_terms_code
yes
no
TrackingD
Warehousing Packaging Tracking Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
ABSID
ABS ID
 
x(8)
 
 
ContainerID
Container ID
 
x(8)
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
MasterTrackingNbr
Master Tracking Nbr
 
x(35)
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
oid_TrackingD
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
QadC01
QAD Field
 
x(24)
0
 
QadC02
QAD Field
 
x(24)
0
 
QadC03
QAD Field
 
x(24)
0
 
QadC04
QAD Field
 
x(24)
0
 
QadD01
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD02
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadI01
QAD Field
 
->,>>>,>>9
 
 
QadI02
QAD Field
 
->,>>>,>>9
 
 
QadI03
QAD Field
 
->,>>>,>>9
 
 
QadL01
QAD Field
 
yes/no
 
 
QadL02
QAD Field
 
yes/no
 
 
QadT01
QAD Field
 
99/99/99
 
 
QadT02
QAD Field
 
99/99/99
 
 
QadT03
QAD Field
 
99/99/99
 
 
ShipVia
Ship Via
 
x(20)
 
 
Site
Site
 
x(8)
 
 
TrackingNumber
Tracking Number
 
x(35)
 
 
TrackingURL
Carrier URL
 
x(65)
 
 
TransMode
Mode of Transport
 
x(20)
 
 
UserC01
User Field Character 1
 
x(24)
 
 
UserC02
User Field Character 2
 
x(24)
 
 
UserC03
User Field Character 3
 
x(24)
 
 
UserC04
User Field Character 4
 
x(24)
 
 
UserC05
User Field Character 5
 
x(24)
 
 
UserD01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserD02
User Field Decimal 2
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserL01
User Field Logical 1
 
yes/no
 
 
UserL02
User Field Logical 2
 
yes/no
 
 
UserT01
User Field Date 1
 
99/99/99
 
 
UserT02
User Field Date 2
 
99/99/99
 
 
Whse
Warehouse
Whse
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 ∗
ABSID
yes
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
ABSID
yes
no
 
 
 
ContainerID
yes
no
 
MasterTrackingNbr
no
Domain
yes
no
 
 
 
MasterTrackingNbr
yes
no
 
 
 
ShipVia
yes
no
 
oid_TrackingD
yes
oid_TrackingD
yes
no
 
SiteWhse
no
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
TrackingNumber
no
Domain
yes
no
 
 
 
TrackingNumber
yes
no
 
 
 
ShipVia
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
UserC01
yes
no
 
 
 
UserC02
yes
no
TranD
Warehousing Transaction Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
ABSID
ABS ID
 
x(8)
 
 
ABSShipFrom
Ship From
 
x(8)
 
 
Addr
Address
 
x(8)
 
 
AlgoNbr
Algorithm
Algo
>>9
 
 
AlgoType
Type
 
X(2)
 
 
AverageTime
Time
 
->>,>>9.99
10
 
BulkPick
Bulk Pick
Bulk!Pick
x(8)
 
 
CloseDate
Closed
 
99/99/99
 
 
CloseProgname
Closed
 
x(10)
 
 
CloseTime
Close Time
 
->,>>>,>>9
 
 
CloseUserID
Closed
 
x(8)
 
 
CmtIndx
Comments
 
>>>>>>>9
 
 
CompDate
Completed Date
 
99/99/99
 
 
CompTime
 
 
->,>>>,>>9
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateProgName
Created ProgName
 
x(10)
 
 
CreateTime
Created Time
 
->,>>>,>>9
 
 
CreateUserID
Created UserID
 
x(8)
 
 
CurrUserID
Current
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
ExistSample
Exist Sample
 
yes/no
 
 
Fail
Fail
 
yes/no
 
 
FromAltUM
From UM
Fr!UM
x(2)
 
 
FromDigit
From Digit
From!Digit
x(8)
 
 
FromLoc
From Location
From!Location
x(8)
 
 
FromLot
From Lot/Serial
 
x(18)
 
 
FromPart
From Item Number
 
x(18)
 
 
FromRef
From Reference
From!Reference
x(8)
 
 
FromSite
From Site
From!Site
x(8)
 
 
FromSlocgp
From SLocGrp
From!SLocGrp
x(8)
 
 
FromWhse
From Whse
From!Whse
x(8)
 
 
FromWlocgp
From WLocGrp
From!WLocGrp
x(8)
 
 
HardAssign
Hard Assignment
Hard
yes/no
 
 
IntRouteCode
Internal Routing
Internal!Routing
x(8)
 
 
IntRouteSeq
Seq
 
>>9
 
 
InventNbr
Internal Inventory ID
Internal!Invent ID
99999999
 
 
IssDSet
Issue Data Set
 
x(12)
 
 
IssLine
Issue Line/ID
Issue!Line/ID
x(8)
 
 
IssNbr
Issue Order
 
x(18)
 
 
IssTrNbr
Issue
 
>>>>>>>>>9
 
 
KeepFromStatus
Keep From Status
Keep!From!Status
yes/no
 
 
ModDate
Modified
 
99/99/99
 
 
ModeM
Mode
 
X(8)
 
 
ModUserID
Modified
 
x(8)
 
 
NumTasks
Num Tasks
 
->>,>>9.99
10
 
oid_TranD
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
OrigFrLoc
Original From Location
Original!From Loc
x(8)
 
 
OrigFrLot
Original From Lot/Serial
Original!From Lot/Serial
x(18)
 
 
OrigFrPart
Original From Item Number
Original!From Item Number
x(18)
 
 
OrigFrRef
Original From Reference
Original!From Ref
x(8)
 
 
OrigToLoc
Original To Location
Original!To Loc
x(8)
 
 
OrigToLot
Original To Lot/Serial
Original!To Lot/Serial
x(18)
 
 
OrigToPart
Original To Item Number
Original!To Item Number
x(18)
 
 
OrigToRef
Original To Reference
Original!To Reference
x(8)
 
 
Project
Project
 
x(8)
 
 
QadC01
QAD Field
 
X(8)
0
 
QadC02
QAD Field
 
X(8)
0
 
QadC03
QAD Field
 
X(8)
0
 
QadC04
QAD Field
 
X(8)
0
 
QadC05
QAD Field
 
X(8)
0
 
QadD01
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD02
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadI01
QAD Field
 
->,>>>,>>9
 
 
QadI02
QAD Field
 
->,>>>,>>9
 
 
QadI03
QAD Field
 
->,>>>,>>9
 
 
QadL01
QAD Field
 
yes/no
 
 
QadL02
QAD Field
 
yes/no
 
 
QadT01
QAD Field
 
99/99/99
 
 
QadT02
QAD Field
 
99/99/99
 
 
QadT03
QAD Field
 
99/99/99
 
 
QtyAct
Actual
 
->,>>>,>>9.9<<<<<<<<
10
 
QtyExp
Expected
 
->,>>>,>>9.9<<<<<<<<
10
 
Reason
Reason
 
x(8)
 
 
RecDSet
Receipt Data Set
 
x(12)
 
 
Receiver
Receiver
 
x(8)
 
 
RecLine
Receipt Line/ID
Receipt!Line/ID
x(8)
 
 
RecNbr
Receipt Order
 
x(18)
 
 
RecReqNbr
Requisition
 
x(8)
 
 
RecTrNbr
Receipt
 
>>>>>>>>>9
 
 
RelNbr
Release Group Nbr
Rel Grp
>>>>>>>9
 
 
Rmks
Remarks
 
x(24)
 
 
SampleID
Sample ID
ID
>>>>>>>9
 
 
SessionID
Session ID
 
x(24)
 
 
Site
Site
 
x(8)
 
 
SOJob
SO Job
 
x(8)
 
 
StageStatus
Stage Status
Stg
x(2)
 
 
StartDate
Started
 
99/99/99
 
 
StartProgname
Started
 
x(10)
 
 
StartTime
Start Time
 
->,>>>,>>9
 
 
StartUserID
Started
 
x(8)
 
 
SystemCode
System
 
x(2)
 
 
SystemProcCode
Procedure Code
Proc
x(2)
 
 
Task
Task
 
x(8)
 
 
ToAltUM
To UM
To!UM
x(2)
 
 
ToDigit
To Digit
 
x(8)
 
 
ToLoc
To Location
To Loc
x(8)
 
 
ToLot
To Lot/Serial
 
x(18)
 
 
ToPart
To Item Number
 
x(18)
 
 
ToRef
To Reference
To!Reference
x(8)
 
 
ToSite
To Site
 
x(8)
 
 
ToSlocGp
To SLocGrp
To!SLocGrp
x(8)
 
 
ToWhse
To Whse
 
x(8)
 
 
ToWlocgp
To WLocGrp
To!WLocGrp
x(8)
 
 
TrNbr
Transaction
Trans
>>>>>>>>>9
 
 
TrPriInc
Increment
 
->,>>>,>>9
 
 
TrPriority
Priority
 
->,>>>,>>9
 
 
TrStatus
Status
St
x(8)
 
 
TrType
Type
 
x(8)
 
 
TwoPhase
Two Phase
2Ph
yes/no
 
 
UltLoc
Ultimate Location
Ultimate!Location
x(8)
 
 
UltSite
Ultimate Site
Ultimate!Site
x(8)
 
 
UltSlocgp
Ultimate SLocGrp
Ultimate!SLocGrp
x(8)
 
 
UltWhse
Ultimate Warehouse
Ultimate!Whse
x(8)
 
 
User1
User 1
 
x(8)
 
 
User2
User 2
 
x(8)
 
 
UserC03
User Field Character 3
 
x(24)
 
 
UserC04
User Field Character 4
 
x(24)
 
 
UserC05
User Field Character 5
 
x(24)
 
 
UserD01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserD02
User Field Decimal 2
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserI01
User Field Integer 1
 
->>>>>>>9
 
 
UserI02
User Field Integer 2
 
->>>>>>>9
 
 
UserL01
User Field Logical 1
 
yes/no
 
 
UserL02
User Field Logical 2
 
yes/no
 
 
UserT01
User Field Date 1
 
99/99/99
 
 
UserT02
User Field Date 1
 
99/99/99
 
 
WaveNbr
Wave Number
Wave Nbr
x(8)
 
 
Whse
Warehouse
Whse
x(8)
 
 
WLocGp
Work Loc Group
WLocGrp
x(8)
 
 
xPrevQtyAct
Previous Actual
Previous!Actual
->,>>>,>>9.9<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
FromLoc
no
Domain
yes
no
 
 
 
FromSite
yes
no
 
 
 
FromWhse
yes
no
 
 
 
FromLoc
yes
no
 
 
 
FromPart
yes
no
 
 
 
FromLot
yes
no
 
 
 
FromRef
yes
no
 
FromPart
no
Domain
yes
no
 
 
 
FromPart
yes
no
 
FromSLocGp
no
Domain
yes
no
 
 
 
FromSite
yes
no
 
 
 
FromWhse
yes
no
 
 
 
FromSlocgp
yes
no
 
 
 
FromPart
yes
no
 
 
 
FromLot
yes
no
 
 
 
FromRef
yes
no
 
 
 
TrNbr
yes
no
 
InventNbr
no
Domain
yes
no
 
 
 
InventNbr
yes
no
 
IssOrder
no
Domain
yes
no
 
 
 
IssDSet
yes
no
 
 
 
IssNbr
yes
no
 
 
 
IssLine
yes
no
 
oid_TranD
yes
oid_TranD
yes
no
 
RecOrder
no
Domain
yes
no
 
 
 
RecDSet
yes
no
 
 
 
RecNbr
yes
no
 
 
 
RecLine
yes
no
 
RelGroup
no
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
RelNbr
yes
no
 
SampleID
no
Domain
yes
no
 
 
 
SampleID
yes
no
 
 
 
TrType
yes
no
 
SessionID
no
Domain
yes
no
 
 
 
SessionID
yes
no
 
SiteWhse
no
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
TrStatus
yes
no
 
StatusTo
no
Domain
yes
no
 
 
 
TrStatus
yes
no
 
 
 
ToSite
yes
no
 
 
 
ToLoc
yes
no
 
Task
no
Domain
yes
no
 
 
 
SystemCode
yes
no
 
 
 
Task
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
ToLoc
no
Domain
yes
no
 
 
 
ToSite
yes
no
 
 
 
ToWhse
yes
no
 
 
 
ToLoc
yes
no
 
 
 
ToPart
yes
no
 
 
 
ToLot
yes
no
 
 
 
ToRef
yes
no
 
ToPart
no
Domain
yes
no
 
 
 
ToPart
yes
no
 ∗
TrNbr
yes
Domain
yes
no
 
 
 
TrNbr
yes
no
 
TrStatus
no
Domain
yes
no
 
 
 
TrStatus
yes
no
 
 
 
SystemCode
yes
no
 
 
 
SystemProcCode
yes
no
 
UltLoc
no
Domain
yes
no
 
 
 
UltSite
yes
no
 
 
 
UltWhse
yes
no
 
 
 
UltSlocgp
yes
no
 
 
 
UltLoc
yes
no
 
UltSiteLoc
no
Domain
yes
no
 
 
 
UltSite
yes
no
 
 
 
UltLoc
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
 
Wave
no
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
WaveNbr
yes
no
 
WLocGp
no
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
WLocGp
yes
no
TranH
Warehousing Transaction History
 
 
Field Name
Label
Col-Label
Format
Dec
 
ABSID
ABS ID
 
x(8)
 
 
ABSShipFrom
Ship From
 
x(8)
 
 
Addr
Address
 
x(8)
 
 
AlgoNbr
Algorithm
Algo
>>9
 
 
AlgoType
Type
 
X(2)
 
 
BulkPick
Bulk Pick
Bulk!Pick
x(8)
 
 
CloseDate
Closed
 
99/99/99
 
 
CloseProgname
Closed
 
x(10)
 
 
CloseTime
 
 
->,>>>,>>9
 
 
CloseUserID
Closed
 
x(8)
 
 
CmtIndx
Comments
 
>>>>>>>9
 
 
CompDate
Completed
 
99/99/99
 
 
CompTime
 
 
->,>>>,>>9
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateProgName
Created
 
x(10)
 
 
CreateTime
Created Time
 
->,>>>,>>9
 
 
CreateUserID
Created UserID
 
x(8)
 
 
CurrUserID
Current
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
ExistSample
Exist Sample
 
yes/no
 
 
Fail
Fail
 
yes/no
 
 
FromAltUM
From UM
Fr!UM
x(2)
 
 
FromDigit
From Digit
From!Digit
x(8)
 
 
FromLoc
From Location
From!Location
x(8)
 
 
FromLot
From Lot/Serial
 
x(18)
 
 
FromPart
From Item Number
 
x(18)
 
 
FromRef
From Reference
From!Reference
x(8)
 
 
FromSite
From Site
From!Site
x(8)
 
 
FromSlocgp
From SLocGrp
From!SLocGrp
x(8)
 
 
FromWhse
From Whse
From!Whse
x(8)
 
 
FromWlocgp
From WLocGrp
From!WLocGrp
x(8)
 
 
HardAssign
Hard Assignment
Hard
yes/no
 
 
IntRouteCode
Internal Routing
Internal!Routing
x(8)
 
 
IntRouteSeq
Seq
 
>>9
 
 
InventNbr
Internal Inventory ID
Internal!Invent ID
99999999
 
 
IssDSet
Issue Data Set
 
x(12)
 
 
IssLine
Issue Line/ID
Issue!Line/ID
x(8)
 
 
IssNbr
Issue Order
 
x(18)
 
 
IssTrNbr
Issue
 
>>>>>>>>>9
 
 
KeepFromStatus
Keep From Status
Keep!From!Status
yes/no
 
 
ModDate
Modified
 
99/99/99
 
 
ModeM
Mode
 
X(8)
 
 
ModUserID
Modified
 
x(8)
 
 
oid_TranH
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
OrigFrLoc
Original From Location
Original!From Loc
x(8)
 
 
OrigFrLot
Original From Lot/Serial
Original!From Lot/Serial
x(18)
 
 
OrigFrPart
Original From Item Number
Original!From Item Number
x(18)
 
 
OrigFrRef
Original From Reference
Original!From Ref
x(8)
 
 
OrigToLoc
Original To Location
Original!To Loc
x(8)
 
 
OrigToLot
Original To Lot/Serial
Original!To Lot/Serial
x(18)
 
 
OrigToPart
Original To Item Number
Original!To Item Number
x(18)
 
 
OrigToRef
Original To Reference
Original!To Reference
x(8)
 
 
Project
Project
 
x(8)
 
 
QadC01
QAD Field
 
X(8)
0
 
QadC02
QAD Field
 
X(8)
0
 
QadC03
QAD Field
 
X(8)
0
 
QadC04
QAD Field
 
X(8)
0
 
QadC05
QAD Field
 
X(8)
0
 
QadD01
QAD Field
 
->>,>>9.99
10
 
QadD02
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadI01
QAD Field
 
->,>>>,>>9
 
 
QadI02
QAD Field
 
->,>>>,>>9
 
 
QadI03
QAD Field
 
->,>>>,>>9
 
 
QadL01
QAD Field
 
yes/no
 
 
QadL02
QAD Field
 
yes/no
 
 
QadT01
QAD Field
 
99/99/99
 
 
QadT02
QAD Field
 
99/99/99
 
 
QadT03
QAD Field
 
99/99/99
 
 
QtyAct
Actual
 
->,>>>,>>9.9<<<<<<<<
10
 
QtyExp
Expected
 
->,>>>,>>9.9<<<<<<<<
10
 
Reason
Reason
 
x(8)
 
 
RecDSet
Receipt Data Set
 
x(12)
 
 
Receiver
Receiver
 
x(8)
 
 
RecLine
Receipt Line/ID
Receipt!Line/ID
x(8)
 
 
RecNbr
Receipt Order
 
x(18)
 
 
RecReqNbr
Requisition
 
x(8)
 
 
RecTrNbr
Receipt
 
>>>>>>>>>9
 
 
RelNbr
Release Group Nbr
Rel Grp
>>>>>>>9
 
 
Rmks
Remarks
 
x(24)
 
 
SampleID
Sample ID
ID
>>>>>>>9
 
 
SessionID
Session ID
 
x(24)
 
 
Site
Site
 
x(8)
 
 
SOJob
SO Job
 
x(8)
 
 
StageStatus
Stage Status
Stg
x(2)
 
 
StartDate
Started
 
99/99/99
 
 
StartProgname
Started
 
x(10)
 
 
StartTime
 
 
->,>>>,>>9
 
 
StartUserID
Started
 
x(8)
 
 
SystemCode
System
 
x(2)
 
 
SystemProcCode
Procedure Code
Proc
x(2)
 
 
Task
Task
 
x(8)
 
 
ToAltUM
To UM
To!UM
x(2)
 
 
ToDigit
To Digit
 
x(8)
 
 
ToLoc
To Location
To Loc
x(8)
 
 
ToLot
To Lot/Serial
 
x(18)
 
 
ToPart
To Item Number
 
x(18)
 
 
ToRef
To Reference
To!Reference
x(8)
 
 
ToSite
To Site
 
x(8)
 
 
ToSlocGp
To SLocGrp
To!SLocGrp
x(8)
 
 
ToWhse
To Whse
 
x(8)
 
 
ToWlocgp
To WLocGrp
To!WLocGrp
x(8)
 
 
TrNbr
Transaction
Trans
>>>>>>>>>9
 
 
TrPriInc
Increment
 
->,>>>,>>9
 
 
TrPriority
Priority
 
->,>>>,>>9
 
 
TrSeq
Sequence
Seq
>>>9
 
 
TrStatus
Status
St
x(8)
 
 
TrType
Type
 
x(8)
 
 
TwoPhase
Two Phase
2Ph
yes/no
 
 
UltLoc
Ultimate Location
Ultimate!Location
x(8)
 
 
UltSite
Ultimate Site
Ultimate!Site
x(8)
 
 
UltSlocgp
Ultimate SLocGrp
Ultimate!SLocGrp
x(8)
 
 
UltWhse
Ultimate Warehouse
Ultimate!Whse
x(8)
 
 
User1
User 1
 
x(8)
 
 
User2
User 2
 
x(8)
 
 
UserC03
User Field Character 3
 
x(24)
 
 
UserC04
User Field Character 4
 
x(24)
 
 
UserC05
User Field Character 5
 
x(24)
 
 
UserD01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserD02
User Field Decimal 2
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserI01
User Field Integer 1
 
->>>>>>>9
 
 
UserI02
User Field Integer 2
 
->>>>>>>9
 
 
UserL01
User Field Logical 1
 
yes/no
 
 
UserL02
User Field Logical 2
 
yes/no
 
 
UserT01
User Field Date 1
 
99/99/99
 
 
UserT02
User Field Date 1
 
99/99/99
 
 
WaveNbr
Wave Number
Wave Nbr
x(8)
 
 
Whse
Warehouse
Whse
x(8)
 
 
WLocGp
Work Loc Group
WLocGrp
x(8)
 
 
xPrevQtyAct
Previous Actual
Previous!Actual
->,>>>,>>9.9<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
CloseUser
no
Domain
yes
no
 
 
 
CloseUserID
yes
no
 
 
 
CloseDate
yes
no
 
 
 
CloseTime
yes
no
 
FromLoc
no
Domain
yes
no
 
 
 
FromSite
yes
no
 
 
 
FromWhse
yes
no
 
 
 
FromLoc
yes
no
 
 
 
FromPart
yes
no
 
 
 
FromLot
yes
no
 
 
 
FromRef
yes
no
 
FromPart
no
Domain
yes
no
 
 
 
FromPart
yes
no
 
FromSLocGp
no
Domain
yes
no
 
 
 
FromSite
yes
no
 
 
 
FromWhse
yes
no
 
 
 
FromSlocgp
yes
no
 
 
 
FromPart
yes
no
 
 
 
FromLot
yes
no
 
 
 
FromRef
yes
no
 
 
 
TrNbr
yes
no
 
 
 
TrSeq
yes
no
 
IssOrder
no
Domain
yes
no
 
 
 
IssDSet
yes
no
 
 
 
IssNbr
yes
no
 
 
 
IssLine
yes
no
 
oid_TranH
yes
oid_TranH
yes
no
 
RecOrder
no
Domain
yes
no
 
 
 
RecDSet
yes
no
 
 
 
RecNbr
yes
no
 
 
 
RecLine
yes
no
 
RelGroup
no
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
RelNbr
yes
no
 
SampleID
no
Domain
yes
no
 
 
 
SampleID
yes
no
 
 
 
TrType
yes
no
 
SessionID
no
Domain
yes
no
 
 
 
SessionID
yes
no
 
StatusTo
no
Domain
yes
no
 
 
 
TrStatus
yes
no
 
 
 
ToSite
yes
no
 
 
 
ToLoc
yes
no
 
Task
no
Domain
yes
no
 
 
 
SystemCode
yes
no
 
 
 
Task
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
ToLoc
no
Domain
yes
no
 
 
 
ToSite
yes
no
 
 
 
ToWhse
yes
no
 
 
 
ToLoc
yes
no
 
 
 
ToPart
yes
no
 
 
 
ToLot
yes
no
 
 
 
ToRef
yes
no
 
ToPart
no
Domain
yes
no
 
 
 
ToPart
yes
no
TrNbrSeq
yes
Domain
yes
no
 
 
 
TrNbr
yes
no
 
 
 
TrSeq
yes
no
 
TrStatus
no
Domain
yes
no
 
 
 
TrStatus
yes
no
 
 
 
SystemCode
yes
no
 
 
 
SystemProcCode
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
 
Wave
no
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
WaveNbr
yes
no
TransactionType
Transaction Type
 
 
Field Name
Label
Col-Label
Format
Dec
 
Country_ID
Link to Country
 
-99999999999
 
 
CustomCombo0
Custom Combo Field
 
x(20)
 
 
CustomCombo1
Custom Combo Field
 
x(20)
 
 
CustomCombo2
Custom Combo Field
 
x(20)
 
 
CustomCombo3
Custom Combo Field
 
x(20)
 
 
CustomCombo4
Custom Combo Field
 
x(20)
 
 
CustomCombo5
Custom Combo Field
 
x(20)
 
 
CustomCombo6
Custom Combo Field
 
x(20)
 
 
CustomCombo7
Custom Combo Field
 
x(20)
 
 
CustomCombo8
Custom Combo Field
 
x(20)
 
 
CustomCombo9
Custom Combo Field
 
x(20)
 
 
CustomDate0
Custom Date Field
 
99/99/9999
 
 
CustomDate1
Custom Date Field
 
99/99/9999
 
 
CustomDate2
Custom Date Field
 
99/99/9999
 
 
CustomDate3
Custom Date Field
 
99/99/9999
 
 
CustomDate4
Custom Date Field
 
99/99/9999
 
 
CustomDecimal0
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal1
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal2
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal3
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal4
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomInteger0
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger1
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger2
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger3
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger4
Custom Integer Field
 
->,>>>,>>9
 
 
CustomLong0
Custom Long Field
 
x(255)
 
 
CustomLong1
Custom Long Field
 
x(255)
 
 
CustomNote
Custom Note Field
 
x(2000)
 
 
CustomShort0
Custom Short Field
 
x(20)
 
 
CustomShort1
Custom Short Field
 
x(20)
 
 
CustomShort2
Custom Short Field
 
x(20)
 
 
CustomShort3
Custom Short Field
 
x(20)
 
 
CustomShort4
Custom Short Field
 
x(20)
 
 
CustomShort5
Custom Short Field
 
x(20)
 
 
CustomShort6
Custom Short Field
 
x(20)
 
 
CustomShort7
Custom Short Field
 
x(20)
 
 
CustomShort8
Custom Short Field
 
x(20)
 
 
CustomShort9
Custom Short Field
 
x(20)
 
 
LastModifiedDate
Last Modified Date
 
99/99/9999
 
 
LastModifiedTime
Last Modified Time
 
99999
 
 
LastModifiedUser
Last Modified User
 
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
TransactionType_ID
Record ID
 
-99999999999
 
 
TransactionTypeCode
Code
 
x(20)
 
 
TransactionTypeDescription
Description
 
x(40)
 
 
TransactionTypeIsActive
Active
 
yes/no
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
ActiveIdx
no
TransactionTypeIsActive
yes
no
 
CntCodeIdx
yes
Country_ID
yes
no
 
 
 
TransactionTypeCode
yes
no
 ∗
Prim
yes
TransactionType_ID
yes
no
 
ViewIndex
no
TransactionTypeIsActive
yes
no
 
 
 
TransactionTypeCode
yes
no
TransportMeans
Means Of Transport
 
 
Field Name
Label
Col-Label
Format
Dec
 
CustomCombo0
Custom Combo Field
 
x(20)
 
 
CustomCombo1
Custom Combo Field
 
x(20)
 
 
CustomCombo2
Custom Combo Field
 
x(20)
 
 
CustomCombo3
Custom Combo Field
 
x(20)
 
 
CustomCombo4
Custom Combo Field
 
x(20)
 
 
CustomCombo5
Custom Combo Field
 
x(20)
 
 
CustomCombo6
Custom Combo Field
 
x(20)
 
 
CustomCombo7
Custom Combo Field
 
x(20)
 
 
CustomCombo8
Custom Combo Field
 
x(20)
 
 
CustomCombo9
Custom Combo Field
 
x(20)
 
 
CustomDate0
Custom Date Field
 
99/99/9999
 
 
CustomDate1
Custom Date Field
 
99/99/9999
 
 
CustomDate2
Custom Date Field
 
99/99/9999
 
 
CustomDate3
Custom Date Field
 
99/99/9999
 
 
CustomDate4
Custom Date Field
 
99/99/9999
 
 
CustomDecimal0
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal1
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal2
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal3
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal4
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomInteger0
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger1
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger2
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger3
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger4
Custom Integer Field
 
->,>>>,>>9
 
 
CustomLong0
Custom Long Field
 
x(255)
 
 
CustomLong1
Custom Long Field
 
x(255)
 
 
CustomNote
Custom Note Field
 
x(2000)
 
 
CustomShort0
Custom Short Field
 
x(20)
 
 
CustomShort1
Custom Short Field
 
x(20)
 
 
CustomShort2
Custom Short Field
 
x(20)
 
 
CustomShort3
Custom Short Field
 
x(20)
 
 
CustomShort4
Custom Short Field
 
x(20)
 
 
CustomShort5
Custom Short Field
 
x(20)
 
 
CustomShort6
Custom Short Field
 
x(20)
 
 
CustomShort7
Custom Short Field
 
x(20)
 
 
CustomShort8
Custom Short Field
 
x(20)
 
 
CustomShort9
Custom Short Field
 
x(20)
 
 
LastModifiedDate
Last Modified Date
 
99/99/9999
 
 
LastModifiedTime
Last Modified Time
 
99999
 
 
LastModifiedUser
Last Modified User
 
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
TransportMeans_ID
Record ID
 
-99999999999
 
 
TransportMeansCode
Code
 
x(20)
 
 
TransportMeansDescription
Description
 
x(40)
 
 
TransportMeansIsActive
Active
 
yes/no
 
 
TransportMeansIsDefault
Default
 
yes/no
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
ActiveIdx
no
TransportMeansIsActive
yes
no
 
CodeIdx
yes
TransportMeansCode
yes
no
 ∗
Prim
yes
TransportMeans_ID
yes
no
 
ViewIndex
no
TransportMeansIsActive
yes
no
 
 
 
TransportMeansCode
yes
no
TranTypeM
Warehousing Transaction Type Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
CmtIndx
Comments
 
>>>>>>>9
 
 
Consolidate
Consolidate
Cons
yes/no
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Description
Description
 
x(24)
 
 
Domain
Domain
 
x(8)
 
 
ModDate
Modified
 
99/99/99
 
 
ModeM
Mode
 
X(8)
 
 
ModUserID
Modified
 
x(8)
 
 
oid_TranTypeM
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
OverPick
Over Pick
Over!Pick
yes/no
 
 
PrintProcCode
Print Procedure Code
Print!Proc
x(2)
 
 
QadC01
QAD Field
 
X(8)
0
 
QadC02
QAD Field
 
X(8)
0
 
QadC03
QAD Field
 
X(8)
0
 
QadC04
QAD Field
 
X(8)
0
 
QadC05
QAD Field
 
X(8)
0
 
QadD01
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD02
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadI01
QAD Field
 
->,>>>,>>9
 
 
QadI02
QAD Field
 
->,>>>,>>9
 
 
QadI03
QAD Field
 
->,>>>,>>9
 
 
QadL01
QAD Field
 
yes/no
 
 
QadL02
QAD Field
 
yes/no
 
 
QadT01
QAD Field
 
99/99/99
 
 
QadT02
QAD Field
 
99/99/99
 
 
QadT03
QAD Field
 
99/99/99
 
 
ShortAction
Shortage Action
Short!Act
>>9
 
 
ShortDef
Shortage Definition
Short!Def
>>9
 
 
ShortQtyDef
Shortage Quantity Definition
Short!Qty Def
>>9
 
 
ShortWindow
Shortage Window
Short!Wind
>>9
 
 
SLGListSearchExt
SLG List Search Extension
SLG List Ext
yes/no
 
 
SLGOPControl
Control Over-Pick at SLG
 
yes/no
 
 
SLGSearchExt
SLG Search Extension
SLG Ext
yes/no
 
 
TrType
Type
 
x(8)
 
 
User1
User 1
 
x(8)
 
 
User2
User 2
 
x(8)
 
 
UserC03
User Field Character 3
 
x(24)
 
 
UserC04
User Field Character 4
 
x(24)
 
 
UserC05
User Field Character 5
 
x(24)
 
 
UserD01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserD02
User Field Decimal 2
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserI01
User Field Integer 1
 
->>>>>>>9
 
 
UserI02
User Field Integer 2
 
->>>>>>>9
 
 
UserL01
User Field Logical 1
 
yes/no
 
 
UserL02
User Field Logical 2
 
yes/no
 
 
UserT01
User Field Date 1
 
99/99/99
 
 
UserT02
User Field Date 1
 
99/99/99
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_TranTypeM
yes
oid_TranTypeM
yes
no
TrType
yes
Domain
yes
no
 
 
 
TrType
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
TranW
Warehousing Transaction Work Table
 
 
Field Name
Label
Col-Label
Format
Dec
 
CreateDate
Create Date
 
99/99/99
 
 
CreateProgName
Created
 
x(10)
 
 
CreateUserID
Created
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
InternalID
Internal User ID
Internal!User ID
x(50)
 
 
ModDate
Modified Date
Mod Date
99/99/99
 
 
ModUserID
User ID
 
x(8)
 
 
oid_TranW
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
QadC01
QAD Field
 
X(8)
0
 
QadC02
QAD Field
 
X(8)
0
 
QadC03
QAD Field
 
X(8)
0
 
QadC04
QAD Field
 
X(8)
0
 
QadC05
QAD Field
 
X(8)
0
 
QadD01
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD02
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadI01
QAD Field
 
->,>>>,>>9
 
 
QadI02
QAD Field
 
->,>>>,>>9
 
 
QadI03
QAD Field
 
->,>>>,>>9
 
 
QadL01
QAD Field
 
yes/no
 
 
QadL02
QAD Field
 
yes/no
 
 
QadT01
QAD Field
 
99/99/99
 
 
QadT02
QAD Field
 
99/99/99
 
 
QadT03
QAD Field
 
99/99/99
 
 
TrNbr
Transaction
Trans
>>>>>>>>>9
 
 
User1
User 1
 
x(8)
 
 
User2
User 2
 
x(8)
 
 
UserC03
User Field Character 3
 
x(24)
 
 
UserC04
User Field Character 4
 
x(24)
 
 
UserC05
User Field Character 5
 
x(24)
 
 
UserD01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserD02
User Field Decimal 2
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserI01
User Field Integer 1
 
->>>>>>>9
 
 
UserI02
User Field Integer 2
 
->>>>>>>9
 
 
UserL01
User Field Logical 1
 
yes/no
 
 
UserL02
User Field Logical 2
 
yes/no
 
 
UserT01
User Field Date 1
 
99/99/99
 
 
UserT02
User Field Date 1
 
99/99/99
 
 
WkType
Type
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_TranW
yes
oid_TranW
yes
no
UserTypeTran
yes
Domain
yes
no
 
 
 
InternalID
yes
no
 
 
 
WkType
yes
no
 
 
 
TrNbr
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
trcs_det
Transaction Cost Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_trcs_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
trcs__qad01
 
 
x(8)
 
 
trcs__qad02
 
 
x(8)
 
 
trcs__qad03
 
 
x(8)
 
 
trcs__qad04
 
 
>>>,>>>,>>9.99
10
 
trcs__qad05
 
 
>>>,>>>,>>9.99
10
 
trcs__qad06
 
 
>>>,>>>,>>9.99
10
 
trcs__qad07
 
 
99/99/99
 
 
trcs__qad08
 
 
99/99/99
 
 
trcs__qad09
 
 
99/99/99
 
 
trcs__qad10
 
 
yes/no
 
 
trcs_bdn_std
Burden
 
->>>,>>>,>>9.99<<<
10
 
trcs_curr
Currency
Cur
x(3)
 
 
trcs_domain
Domain
 
x(8)
 
 
trcs_ex_rate
Exch Rate
 
>>,>>9.99999<<<<<
10
 
trcs_lbr_std
Labor
 
->>>,>>>,>>9.99<<<
10
 
trcs_mtl_std
Material
 
->>>,>>>,>>9.99<<<
10
 
trcs_ovh_std
Overhead
 
>>>>,>>>,>>9.99<<<
10
 
trcs_price
Price
 
->>>,>>>,>>9.99<<<
10
 
trcs_set
Cost Set
 
x(8)
 
 
trcs_sub_std
Subcontract
 
->>>,>>>,>>9.99<<<
10
 
trcs_trnbr
Trans
 
>>>>>>>>>>
 
 
trcs_user1
Ufld1
 
x(8)
 
 
trcs_user2
Ufld2
 
x(8)
 
 
trcs_userid
User ID
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_trcs_det
yes
oid_trcs_det
yes
no
trcs_nbr_set
yes
trcs_domain
yes
no
 
 
 
trcs_trnbr
yes
no
 
 
 
trcs_set
yes
no
trgl_det
Inventory Transaction and General Ledger Cross-Reference
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_trgl_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
trgl__qadc01
 
 
x(8)
 
 
trgl_cr_acct
Cr Acct
 
x(8)
 
 
trgl_cr_cc
Cr Cost Ctr
CC
x(4)
 
 
trgl_cr_line
Line
 
>>>9
 
 
trgl_cr_proj
Cr Project
Project
x(8)
 
 
trgl_cr_sub
Cr Sub-Acct
Sub-Acct
x(8)
 
 
trgl_domain
Domain
 
x(8)
 
 
trgl_dr_acct
Dr Acct
 
x(8)
 
 
trgl_dr_cc
Dr Cost Ctr
CC
x(4)
 
 
trgl_dr_line
Line
 
>>>9
 
 
trgl_dr_proj
Dr Project
Project
x(8)
 
 
trgl_dr_sub
Dr Sub-Acct
Sub-Acct
x(8)
 
 
trgl_dy_code
Daybook
 
x(8)
 
 
trgl_dy_num
Entry Number
 
x(40)
 
 
trgl_eff_trans
Current
 
yes/no
 
 
trgl_gl_amt
Amount
 
->>>>>,>>9.99
10
 
trgl_gl_ref
GL Reference
 
x(14)
 
 
trgl_sequence
Sequence
 
->,>>>,>>9
 
 
trgl_trnbr
Transaction
Trans
>>>>>>>>>9
 
 
trgl_type
Type
 
x(8)
 
 
trgl_user1
Ufld1
 
x(8)
 
 
trgl_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_trgl_det
yes
oid_trgl_det
yes
no
 
trgl_dr_cr
no
trgl_domain
yes
no
 
 
 
trgl_dr_acct
yes
no
 
 
 
trgl_dr_sub
yes
no
 
 
 
trgl_dr_cc
yes
no
 
 
 
trgl_cr_acct
yes
no
 
 
 
trgl_cr_sub
yes
no
 
 
 
trgl_cr_cc
yes
no
 
trgl_dy_code
no
trgl_domain
yes
no
 
 
 
trgl_dy_code
yes
no
 
 
 
trgl_dy_num
yes
no
trgl_nbr_ref
yes
trgl_domain
yes
no
 
 
 
trgl_trnbr
yes
no
 
 
 
trgl_gl_ref
yes
no
 
 
 
trgl_sequence
yes
no
 
trgl_ref_nbr
no
trgl_domain
yes
no
 
 
 
trgl_gl_ref
yes
no
 
 
 
trgl_trnbr
yes
no
 
trgl_type_nbr_ref
no
trgl_domain
yes
no
 
 
 
trgl_type
yes
no
 
 
 
trgl_trnbr
yes
no
 
 
 
trgl_gl_ref
yes
no
trld_det
Trailer Tax Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_trld_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
trld__chr01
 
 
x(8)
 
 
trld__log01
 
 
yes/no
 
 
trld__qad01
 
 
x(8)
 
 
trld__qad02
 
 
x(8)
 
 
trld__qad03
 
 
->>>,>>>,>>9.99
10
 
trld__qad04
 
 
99/99/99
 
 
trld__qad05
 
 
yes/no
 
 
trld_code
Trailer Code
Trl!Code
x(4)
 
 
trld_domain
Domain
 
x(8)
 
 
trld_tax_type
Tax Type
 
x(16)
 
 
trld_taxable
Taxable
 
yes/no
 
 
trld_taxc
Tax Class
TxC
x(3)
 
 
trld_user1
Ufld1
 
x(8)
 
 
trld_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_trld_det
yes
oid_trld_det
yes
no
trld_code_type
yes
trld_domain
yes
no
 
 
 
trld_code
yes
no
 
 
 
trld_tax_type
yes
no
trl_mstr
Trailer Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_trl_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
trl__qadc01
 
 
x(8)
 
 
trl_acct
Trailer Acct
Acct
x(8)
 
 
trl_cc
Trailer CC
CC
x(4)
 
 
trl_code
Trailer Code
Code
x(2)
 
 
trl_desc
Description
 
x(24)
 
 
trl_domain
Domain
 
x(8)
 
 
trl_fst
FST
 
yes/no
 
 
trl_project
Project
 
x(8)
 
 
trl_pst
PST
 
yes/no
 
 
trl_sub
Trailer Sub-Acct
Sub-Acct
x(8)
 
 
trl_taxable
Taxable
 
yes/no
 
 
trl_taxc
Tax Class
TxC
x(3)
 
 
trl_user1
Ufld1
 
x(8)
 
 
trl_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_trl_mstr
yes
oid_trl_mstr
yes
no
trl_code
yes
trl_domain
yes
no
 
 
 
trl_code
yes
no
trq_mstr
Transmission Date Reference Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_trq_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
trq__qadc01
 
 
x(8)
 
 
trq_add_ref
Add Ref
 
x(8)
 
 
trq_doc_ref
Doc Ref
 
x(8)
 
 
trq_doc_type
Doc Type
 
x(3)
 
 
trq_domain
Domain
 
x(8)
 
 
trq_id
Transmission Number
Transm
>>>>>>9
 
 
trq_mod_date
Modified Date
Mod Date
99/99/99
 
 
trq_mod_userid
User ID
 
x(16)
 
 
trq_msg_type
Type
 
x(8)
 
 
trq_user1
Ufld1
 
x(8)
 
 
trq_user2
Ufld2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_trq_mstr
yes
oid_trq_mstr
yes
no
 
trq_doc_type
yes
trq_domain
yes
no
 
 
 
trq_doc_type
yes
no
 
 
 
trq_doc_ref
yes
no
 
 
 
trq_add_ref
yes
no
trq_id
yes
trq_domain
yes
no
 
 
 
trq_id
yes
no
tr_hist
Inventory Transaction History
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_lgd_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_tr_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
tr__chr01
 
 
x(8)
 
 
tr__chr02
 
 
x(8)
 
 
tr__chr03
 
 
x(8)
 
 
tr__chr04
 
 
x(8)
 
 
tr__chr05
 
 
x(8)
 
 
tr__chr06
 
 
x(8)
 
 
tr__chr07
 
 
x(8)
 
 
tr__chr08
 
 
x(8)
 
 
tr__chr09
 
 
x(8)
 
 
tr__chr10
 
 
x(8)
 
 
tr__chr11
 
 
x(8)
 
 
tr__chr12
 
 
x(8)
 
 
tr__chr13
 
 
x(8)
 
 
tr__chr14
 
 
x(8)
 
 
tr__chr15
 
 
x(8)
 
 
tr__dec01
 
 
>>>,>>>,>>9.99
10
 
tr__dec02
 
 
>>>,>>>,>>9.99
10
 
tr__dec03
 
 
>>>,>>>,>>9.99
10
 
tr__dec04
 
 
>>>,>>>,>>9.99
10
 
tr__dec05
 
 
>>>,>>>,>>9.99
10
 
tr__dte01
 
 
99/99/99
 
 
tr__dte02
 
 
99/99/99
 
 
tr__dte03
 
 
99/99/99
 
 
tr__dte04
 
 
99/99/99
 
 
tr__dte05
 
 
99/99/99
 
 
tr__log01
 
 
yes/no
 
 
tr__log02
 
 
yes/no
 
 
tr_addr
Address
 
x(8)
 
 
tr_assay
Assay %
 
>>9.99%
10
 
tr_auto_install
Auto Installed
 
yes/no
 
 
tr_batch
Batch
 
x(18)
 
 
tr_bdn_std
Burden
 
->>>,>>>,>>9.99<<<
10
 
tr_begin_qoh
Begin Balance
 
->,>>>,>>9.9<<<<<<<<
10
 
tr_ca_int_type
Work Code
 
x(8)
 
 
tr_ca_opn_date
 
 
99/99/99
 
 
tr_covered_amt
Covered Amount
 
>>>>,>>>,>>9.99<<<
10
 
tr_cprice
Price
 
>>>>,>>>,>>9.99<<<
10
 
tr_curr
Currency
Cur
x(3)
 
 
tr_date
Date
 
99/99/99
 
 
tr_daycode
Day Code
 
x(8)
 
 
tr_doc_id
Document ID
 
x(24)
 
 
tr_domain
Domain
 
x(8)
 
 
tr_effdate
Effective
Eff Date
99/99/99
 
 
tr_enduser
End User
 
X(8)
 
 
tr_eng_area
Service Area
Area
x(18)
 
 
tr_eng_code
Engineer Code
Eng Code
x(8)
 
 
tr_ex_rate
Exch Rate
 
>>>>,>>>,>>9.9<<<<<<<<<
10
 
tr_ex_rate2
Exch Rate 2
 
>>>>,>>>,>>9.9<<<<<<<<<
10
 
tr_ex_ratetype
Rate Type
 
x(8)
 
 
tr_expire
Expire Date
 
99/99/99
 
 
tr_exru_seq
Sequence
 
>>>>>>>>9
 
 
tr_fcg_code
Charge Code
 
x(8)
 
 
tr_fldchg_cmtindx
Comment
 
>>>>>>>9
 
 
tr_for
Service Part
 
x(18)
 
 
tr_fsc_code
Service Category
 
x(8)
 
 
tr_fsm_type
FSM Type
 
x(8)
 
 
tr_gl_amt
Amount
 
->>>>>,>>9.99
10
 
tr_gl_date
GL Date
 
99/99/99
 
 
tr_grade
Grade
 
x(2)
 
 
tr_intercompanyref
Inter Company Reference
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
tr_last_date
Last Activity
 
99/99/99
 
 
tr_lbr_std
Labor
 
->>>,>>>,>>9.99<<<
10
 
tr_line
Line
Ln
>>9
 
 
tr_loc
Loc
Location
x(8)
 
 
tr_loc_begin
Begin Loc Bal
 
->,>>>,>>9.9<<<<<<<<
10
 
tr_lot
ID
 
x(8)
 
 
tr_msg
Message Number
Msg
>>>>9
 
 
tr_mtl_std
Material
 
->>>,>>>,>>9.99<<<
10
 
tr_nbr
Order
 
x(18)
 
 
tr_ord_rev
Revision
Rev
>>9
 
 
tr_ovh_std
Overhead
 
>>>>,>>>,>>9.99<<<
10
 
tr_part
Item Number
 
x(18)
 
 
tr_pc_sequence
PC Sequence
 
>>>>>>>>>>>>>>>>>>9
 
 
tr_per_date
Performance Date
Perform
99/99/99
 
 
tr_price
Price
 
->>>,>>>,>>9.99<<<
10
 
tr_prod_line
Product Line
Line
x(4)
 
 
tr_program
Program
 
x(12)
 
 
tr_promise_date
Promise Date
Promise
99/99/99
 
 
tr_qty_chg
Qty Change
 
->,>>>,>>9.9<<<<<<<<
10
 
tr_qty_cn_adj
Consignment Qty Adjusted
 
->,>>>,>>9.9<<<<<<<<
10
 
tr_qty_loc
Loc Qty Change
 
->,>>>,>>9.9<<<<<<<<
10
 
tr_qty_req
Qty Required
 
->,>>>,>>9.9<<<<<<<<
10
 
tr_qty_short
Qty Short
 
->,>>>,>>9.9<<<<<<<<
10
 
tr_ref
Ref
Reference
x(8)
 
 
tr_ref_site
Reference Site
Ref Site
x(8)
 
 
tr_rev
Rev
 
x(4)
 
 
tr_rmks
Remarks
 
x(10)
 
 
tr_rsn_code
Reason
 
x(8)
 
 
tr_sa_nbr
Contract
 
x(8)
0
 
tr_serial
Lot/Serial
 
x(18)
 
 
tr_ship_date
Ship Date
 
99/99/99
 
 
tr_ship_id
Shipper Number
 
x(20)
 
 
tr_ship_inv_mov
Inventory Movement Code
Inv Mov
x(8)
 
 
tr_ship_type
Ship Type
T
x(1)
 
 
tr_site
Site
 
x(8)
 
 
tr_slspsn[4]
Salesperson
Salespsn
x(8)
 
 
tr_so_job
Sales/Job
 
x(8)
 
 
tr_status
Inventory Status
Status
x(8)
 
 
tr_sub_std
Subcontract
 
->>>,>>>,>>9.99<<<
10
 
tr_sv_code
Contract Type
 
x(8)
 
 
tr_svc_type
 
 
x(1)
 
 
tr_sys_prod
System Product Line
S Prod
x(4)
 
 
tr_time
Time
 
>>,>>>,>>9
 
 
tr_trnbr
Trans
 
>>>>>>>>>>
 
 
tr_type
Trans Type
Type
x(8)
 
 
tr_um
UM
 
x(2)
 
 
tr_upd_isb
 
 
yes/no
 
 
tr_user1
Ufld1
 
x(8)
 
 
tr_user2
Ufld2
 
x(8)
 
 
tr_userid
User ID
 
x(8)
 
 
tr_vend_date
Supplier Production Date
Prod Date
99/99/99
 
 
tr_vend_lot
Supplier Lot
 
x(18)
 
 
tr_wo_due_date
Due Date
Due
99/99/99
 
 
tr_wo_line
Production Line
Line
x(8)
 
 
tr_wo_qty_comp
Qty Completed
 
->,>>>,>>9.9<<<<<<<<
10
 
tr_wo_qty_ord
Qty Ordered
 
->,>>>,>>9.9<<<<<<<<
10
 
tr_wo_yield_pct
Yield
 
>>9.99%
10
 
tr_wod_op
Operation
Op
>>>>>>
 
 
tr_xcr_acct
Not Used. Cr Acct
 
x(8)
 
 
tr_xcr_cc
Not Used. Cr Cost Ctr
CC
x(4)
 
 
tr_xcr_proj
Not used. Cr Project
Project
x(8)
 
 
tr_xdr_acct
Not used. Dr Acct
 
x(8)
 
 
tr_xdr_cc
Not used. Dr Cost Ctr
CC
x(4)
 
 
tr_xdr_proj
Not used. Dr Project
Project
x(8)
 
 
tr_xgl_ref
Not used. GL Reference
 
x(14)
 
 
tr_xslspsn1
Salesperson 1
Salespsn
x(8)
 
 
tr_xslspsn2
Salesperson 2
Salespsn
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_tr_hist
yes
oid_tr_hist
yes
no
 
tr_addr_eff
no
tr_domain
yes
no
 
 
 
tr_addr
yes
no
 
 
 
tr_effdate
yes
no
 
tr_batch
no
tr_domain
yes
no
 
 
 
tr_batch
yes
no
 
tr_date_trn
yes
tr_domain
yes
no
 
 
 
tr_date
yes
no
 
 
 
tr_trnbr
yes
no
 
tr_eff_trnbr
no
tr_domain
yes
no
 
 
 
tr_effdate
yes
no
 
 
 
tr_trnbr
yes
no
 
tr_nbr_eff
no
tr_domain
yes
no
 
 
 
tr_nbr
yes
no
 
 
 
tr_effdate
yes
no
 
tr_nbr_rmks_type
no
tr_domain
yes
no
 
 
 
tr_nbr
yes
no
 
 
 
tr_rmks
yes
no
 
 
 
tr_type
yes
no
 
tr_oid_lgd_mstr
no
oid_lgd_mstr
yes
no
 
tr_part_eff
no
tr_domain
yes
no
 
 
 
tr_part
yes
no
 
 
 
tr_effdate
yes
no
 
tr_part_trn
no
tr_domain
yes
no
 
 
 
tr_part
yes
no
 
 
 
tr_trnbr
yes
no
 
tr_serial
no
tr_domain
yes
no
 
 
 
tr_serial
yes
no
 
tr_shipper
no
tr_domain
yes
no
 
 
 
tr_ship_inv_mov
yes
no
 
 
 
tr_ship_id
yes
no
tr_trnbr
yes
tr_domain
yes
no
 
 
 
tr_trnbr
yes
no
 
tr_type
no
tr_domain
yes
no
 
 
 
tr_type
yes
no
 
 
 
tr_effdate
yes
no
 
tr_vend_lot
no
tr_domain
yes
no
 
 
 
tr_vend_lot
yes
no
tx2d_det
Tax Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_tx2d_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
tx2d__chr01
 
 
x(8)
 
 
tx2d__chr02
 
 
x(8)
 
 
tx2d__dec01
 
 
->>>,>>>,>>9.99
10
 
tx2d__dec02
 
 
->>>,>>>,>>9.99
10
 
tx2d__dte01
 
 
99/99/99
 
 
tx2d__log01
 
 
yes/no
 
 
tx2d__qad01
 
 
x(8)
 
 
tx2d__qad02
 
 
x(8)
 
 
tx2d__qad03
 
 
yes/no
 
 
tx2d__qad04
 
 
->>>,>>>,>>9.99
10
 
tx2d__qad05
 
 
99/99/99
 
 
tx2d__qadd01[3]
 
 
->>>,>>>,>>9.99<
10
 
tx2d__qadd02[10]
 
 
->>>,>>>,>>9.99<
10
 
tx2d_abs_ret_amt
Base Absorbed/Retained
 
->>,>>>,>>9.99
10
 
tx2d_by_line
Tax-By-Line
By!Line
yes/no
 
 
tx2d_carrier
Carrier
 
x(8)
 
 
tx2d_cur_abs_ret_amt
Absorbed/Retained
 
->>,>>>,>>9.99
10
 
tx2d_cur_nontax_amt
Non-taxable
 
->>,>>>,>>9.99
10
 
tx2d_cur_recov_amt
Recoverable
 
->>,>>>,>>9.99
10
 
tx2d_cur_tax_amt
Tax
 
->>,>>>,>>9.99
10
 
tx2d_curr
Currency
Cur
x(3)
 
 
tx2d_domain
Domain
 
x(8)
 
 
tx2d_edited
Edited
Ed
yes/no
 
 
tx2d_effdate
Tax Date
 
99/99/99
 
 
tx2d_ent_abs_ret_amt
Entity Absorbed/Retained
 
->>,>>>,>>9.99
10
 
tx2d_ent_nontax_amt
Entity Non-Taxable
 
->>,>>>,>>9.99
10
 
tx2d_ent_recov_amt
Entity Recoverable
 
->>,>>>,>>9.99
10
 
tx2d_ent_tax_amt
Entity Tax
 
->>,>>>,>>9.99
10
 
tx2d_line
Line
 
>>>>>>>9
 
 
tx2d_line_site_ent
Line Site Entity
 
x(4)
 
 
tx2d_markup_amt
Markup tax amount
 
->,>>>,>>>,>>9.99
10
 
tx2d_markup_pct
Markup percentage
 
->>9.99<<%
10
 
tx2d_mgmt_abs_ret_amt
Statutory Absorbed/Retained
 
->>,>>>,>>9.99
10
 
tx2d_mgmt_nontax_amt
Statutory Non-Taxable
 
->>,>>>,>>9.99
10
 
tx2d_mgmt_recov_amt
Statutory Recoverable
 
->>,>>>,>>9.99
10
 
tx2d_mgmt_tax_amt
Statutory Tax
 
->>,>>>,>>9.99
10
 
tx2d_nbr
Number
 
x(8)
 
 
tx2d_nontax_amt
Base Non-Taxable
 
->>,>>>,>>9.99
10
 
tx2d_posted_date
Posted Date
Post!Date
99/99/99
 
 
tx2d_rcpt_tax_point
Accrue Tax at Receipt
 
yes/no
 
 
tx2d_recov_amt
Base Recoverable
 
->>,>>>,>>9.99
10
 
tx2d_ref
Reference
Ref
x(42)
 
 
tx2d_tax_amt
Base Tax
 
->>,>>>,>>9.99
10
 
tx2d_tax_code
Tax Code
 
x(8)
 
 
tx2d_tax_env
Tax Environment
Tax!Env
x(16)
 
 
tx2d_tax_in
Tax In
Tax!In
yes/no
 
 
tx2d_tax_pct
Tax Percentage
Tax %
->>9.99<<%
10
 
tx2d_tax_type
Tax Type
 
x(16)
 
 
tx2d_tax_usage
Tax Usage
Tax!Usage
x(8)
 
 
tx2d_taxable_amt
Base Taxable
 
->>,>>>,>>9.99
10
 
tx2d_taxc
Tax Class
Tax!Class
x(3)
 
 
tx2d_totamt
Total Amount
 
->>,>>>,>>9.99
10
 
tx2d_tottax
Taxable Sales
Taxable!Sales
->>,>>>,>>9.99
10
 
tx2d_tr_type
Transaction Type
TT
x(2)
 
 
tx2d_trans_ent
Transaction Entity
 
x(4)
 
 
tx2d_trl
Trailer
Trl
x(18)
 
 
tx2d_usage_tax_point
Accrue Tax At Usage
Accrue Tax!At Usage
yes/no
 
 
tx2d_user1
Ufld1
 
x(8)
 
 
tx2d_user2
Ufld2
 
x(8)
 
 
tx2d_zone_from
Ship-From Tax Zone
 
x(16)
 
 
tx2d_zone_to
Ship-To Tax Zone
 
x(16)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_tx2d_det
yes
oid_tx2d_det
yes
no
 
tx2d_carrier
no
tx2d_domain
yes
no
 
 
 
tx2d_carrier
yes
no
tx2d_ref_nbr
yes
tx2d_domain
yes
no
 
 
 
tx2d_ref
yes
no
 
 
 
tx2d_nbr
yes
no
 
 
 
tx2d_line
yes
no
 
 
 
tx2d_trl
yes
no
 
 
 
tx2d_tr_type
yes
no
 
 
 
tx2d_tax_code
yes
no
 
tx2d_tax_code
no
tx2d_domain
yes
no
 
 
 
tx2d_tax_code
yes
no
tx2_mstr
Tax Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_tx2_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
tx2__chr01
 
 
x(8)
 
 
tx2__chr02
 
 
x(8)
 
 
tx2__dec01
 
 
->>>,>>>,>>9.99
10
 
tx2__dec02
 
 
->>>,>>>,>>9.99
10
 
tx2__dte01
 
 
99/99/99
 
 
tx2__log01
 
 
yes/no
 
 
tx2__qad01
 
 
x(8)
 
 
tx2__qad02
 
 
x(8)
 
 
tx2__qad03
 
 
yes/no
 
 
tx2__qad04
 
 
->>>,>>>,>>9.99
10
 
tx2__qad05
 
 
99/99/99
 
 
tx2__qadc01[2]
 
 
x(8)
 
 
tx2__qadc02[2]
 
 
x(4)
 
 
tx2_ab_cn_tx_grp
Absorbed CN Tax Group
Abs CN Tax Grp
x(20)
 
 
tx2_ab_inv_tx_grp
Absorbed Inv Tax Group
Abs Inv Tax Grp
x(20)
 
 
tx2_ap_acct
AP Tax Account
 
x(8)
 
 
tx2_ap_cc
CC
 
x(4)
 
 
tx2_ap_cn_acct
AP Tax CN Account
AP Tax CN Acct
x(8)
 
 
tx2_ap_cn_sub
AP Tax CN Sub-Account
AP Tax CN Sub-Acct
x(8)
 
 
tx2_ap_dis_acct
AP Discount Account
AP Disc Acct
x(8)
 
 
tx2_ap_dis_sub
AP Discount Sub-Account
AP Disc Sub-Acct
x(8)
 
 
tx2_ap_disc_acct
AP Discount Account
 
x(8)
 
 
tx2_ap_disc_cc
CC
 
x(4)
 
 
tx2_ap_disc_sub
AP Discount Sub-Account
Sub-Acct
x(8)
 
 
tx2_ap_sub
AP Tax Sub-Account
Sub-Acct
x(8)
 
 
tx2_apr_acct
AP Retained Tax Account
 
x(8)
 
 
tx2_apr_cc
CC
 
x(4)
 
 
tx2_apr_cn_acct
AP Tax Ret CN Account
AP Tax Ret CN Acct
x(8)
 
 
tx2_apr_cn_sub
AP Tax Ret CN Sub-Account
AP Tax Ret CN Sub-Acct
x(8)
 
 
tx2_apr_sub
AP Retained Tax sub
Sub-Acct
x(8)
 
 
tx2_apr_use
 
 
yes/no
 
 
tx2_ar_acct
AR Sales Tax Account
 
x(8)
 
 
tx2_ar_cc
CC
 
x(4)
 
 
tx2_ar_cn_acct
Sales Tax CN Account
Sales Tax CN Acct
x(8)
 
 
tx2_ar_cn_sub
Sales Tax CN Sub-Account
Sales Tax CN Sub-Acct
x(8)
 
 
tx2_ar_dis_acct
AR Discount Account
AR Disc Acct
x(8)
 
 
tx2_ar_dis_sub
AR Discount Sub-Account
AR Disc Sub-Acct
x(8)
 
 
tx2_ar_disc_acct
AR Discount Account
 
x(8)
 
 
tx2_ar_disc_cc
CC
 
x(4)
 
 
tx2_ar_disc_sub
AR Discount Sub-Account
Sub-Acct
x(8)
 
 
tx2_ar_sub
AR Sales Tax Sub-Acct
Sub-Acct
x(8)
 
 
tx2_ara_acct
AR Absorbed Tax Account
 
x(8)
 
 
tx2_ara_cc
CC
 
x(4)
 
 
tx2_ara_cn_acct
Sales Tax Abs CN Acct
 
x(8)
 
 
tx2_ara_cn_sub
Sales Tax Abs CN Sub-Acct
 
x(8)
 
 
tx2_ara_sub
AR Absorbed Tax Sub
Sub-Acct
x(8)
 
 
tx2_ara_use
 
 
yes/no
 
 
tx2_base
Taxable Base Code
Tax Base
x(8)
 
 
tx2_by_line
Tax-By-Line
By!Line
yes/no
 
 
tx2_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
tx2_cn_tx_grp
Customer Credit Note Tax Group
Cust CN Tax Grp
x(20)
 
 
tx2_cr_voc_tx_grp
Supplier CN Tax Group
Sup CN Tax Grp
x(20)
 
 
tx2_cst_code
CST Code
 
x(2)
 
 
tx2_curr
Currency
Cur
x(3)
 
 
tx2_daybookset
Daybook Set
Dybk Set
x(8)
 
 
tx2_desc
Description
 
x(24)
 
 
tx2_dltx_cn_acct
Delayed Tax CN Account
Delayed Tax CN Acct
x(8)
 
 
tx2_dltx_cn_sub
Delayed Tax CN Sub-Account
Delayed Tax CN Sub-Acct
x(8)
 
 
tx2_dltx_inv_acct
Delayed Tax Invoice Account
Delayed Tax Inv Acct
x(8)
 
 
tx2_dltx_inv_sub
Delayed Tax Invoice Sub-Account
Delayed Tax Inv Sub-Acct
x(8)
 
 
tx2_domain
Domain
 
x(8)
 
 
tx2_ec_process_work
EC Process Work
 
yes/no
 
 
tx2_ec_sales_list
EC Sales List
 
yes/no
 
 
tx2_effdate
Effective
 
99/99/99
 
 
tx2_exp_date
Expiration Date
Expiration!Date
99/99/99
 
 
tx2_group
Tax Group
 
x(8)
 
 
tx2_inv_disc
Discount Tax at Invoice
Disc!Inv
yes/no
 
 
tx2_inv_tx_grp
Customer Invoice Tax Group
Cust Inv Tax Grp
x(20)
 
 
tx2_markup_pct
Markup Percent
 
->>9.99<<%
10
 
tx2_max
Maximum Taxable Amount
Max Amount
>>>,>>>,>>>,>>9.99<
10
 
tx2_method
Tax Method
Tax!Meth
x(2)
 
 
tx2_min
Minimum Taxable Amount
Min Taxable
>>>,>>>,>>>,>>9.99<
10
 
tx2_mod_date
Modified Date
Mod Date
99/99/99
 
 
tx2_pct_recv
Percent Recoverable
Pct Recov
->>9.99<<%
10
 
tx2_pmt_disc
Discount Tax at Payment
Disc!Pmt
yes/no
 
 
tx2_pt_taxc
Item Tax Class
TxC
x(3)
 
 
tx2_rcpt_tax_point
Accrue Tax at Receipt
 
yes/no
 
 
tx2_register
Tax Register
 
x(2)
 
 
tx2_ret_cr_voc_tx_grp
Retained CN Tax Group
Retained CN Tax Grp
x(20)
 
 
tx2_ret_voc_tx_grp
Retained Invoice Tax Group
Retained Inv Tax Grp
x(20)
 
 
tx2_reverse_charge
Domestic Reverse Charge
 
yes/no
 
 
tx2_stx_acct
Suspended Tax Account
 
x(8)
 
 
tx2_stx_cc
CC
 
x(4)
 
 
tx2_stx_cn_acct
Suspended Tax CN Account
Susp Tax CN Acct
x(8)
 
 
tx2_stx_cn_sub
Suspended Tax CN Sub-Account
Susp Tax CN Sub-Acct
x(8)
 
 
tx2_stx_dltx_use
Suspended/Delayed Taxes
Sus/Del!Taxes
yes/no
 
 
tx2_stx_inv_acct
Suspended Tax Inv Account
Susp Tax Inv Acct
x(8)
 
 
tx2_stx_inv_sub
Suspended Tax Inv Sub-Account
Susp Tax Inv Sub-Acct
x(8)
 
 
tx2_stx_sub
Suspended Tax Sub Account
Sub-Acct
x(8)
 
 
tx2_tax_code
Tax Code
 
x(8)
 
 
tx2_tax_in
Allow Tax Included
 
yes/no
 
 
tx2_tax_pct
Tax Rate
 
->>9.99<<%
10
 
tx2_tax_type
Tax Type
 
x(16)
 
 
tx2_tax_usage
Tax Usage
TaxUsage
x(8)
 
 
tx2_trl_taxable
Tax Trailer Amounts
Tax Trl
yes/no
 
 
tx2_update_tax
Update Tax Allowed
Upd!Tax
yes/no
 
 
tx2_usage_tax_point
Accrue Tax At Usage
Accrue Tax!At Usage
yes/no
 
 
tx2_user1
Ufld1
 
x(8)
 
 
tx2_user2
Ufld2
 
x(8)
 
 
tx2_userid
User ID
 
x(8)
 
 
tx2_voc_tx_grp
Supplier Invoice Tax Group
Sup Inv Tax Grp
x(20)
 
 
tx2_wht_amt_for_100
Amount for Withhold 100% VAT
 
->>,>>9.99<
10
 
tx2_wht_fix_amt
Fixed Amount
 
->>,>>9.99<
10
 
tx2_wht_gi_jurisdiction_code
Gross Income Jurisdiction
 
x(8)
 
 
tx2_wht_magnetic_file
Include in Files
 
yes/no
 
 
tx2_wht_min_amt
Minimum Withhold Amount
 
->>,>>9.99<
10
 
tx2_wht_min_nontax_amt
Minimum Non-taxable Amount
 
->>,>>9.99<
10
 
tx2_wht_regime_code
Regime Code
 
x(8)
 
 
tx2_wht_rg738_operation_code
Operation Code RG738
 
x(8)
 
 
tx2_wht_rg738_tax_code
Tax Code RG738
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_tx2_mstr
yes
oid_tx2_mstr
yes
no
 
tx2_register
no
tx2_domain
yes
no
 
 
 
tx2_register
yes
no
tx2_tax_code
yes
tx2_domain
yes
no
 
 
 
tx2_tax_code
yes
no
 
tx2_type_taxc
yes
tx2_domain
yes
no
 
 
 
tx2_tax_type
yes
no
 
 
 
tx2_pt_taxc
yes
no
 
 
 
tx2_tax_usage
yes
no
 
 
 
tx2_effdate
yes
no