QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
AAA_F_20170523
Generated Finance Info
 
 
Field Name
Label
Col-Label
Format
Dec
 
aaa_id
 
 
>9
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
aaa_idx
yes
aaa_id
yes
no
abscc_det
Sales Order Detail Container Charges
 
 
Field Name
Label
Col-Label
Format
Dec
 
abscc__qadc01
 
 
x(24)
 
 
abscc__qadc02
 
 
x(24)
 
 
abscc_abs_id
ID
 
x(20)
 
 
abscc_abs_shipfrom
Ship From
 
x(8)
 
 
abscc_charge_type
Charge Type
Charge!Type
x(8)
 
 
abscc_confirmed
Confirmed
 
yes/no
 
 
abscc_cont_price
Price
 
->>>>,>>>,>>9.99<<<
10
 
abscc_container
Container
 
x(18)
 
 
abscc_domain
Domain
 
x(8)
 
 
abscc_fr_class
Freight Class
 
x(8)
 
 
abscc_inv_nbr
Invoice Number
 
x(22)
 
 
abscc_inv_post
Posted
 
yes/no
 
 
abscc_mod_date
Modified Date
Mod Date
99/99/99
 
 
abscc_mod_userid
User ID
 
x(8)
 
 
abscc_ord_line
SO Line
SO!Line
>>9
 
 
abscc_order
Sales Order
 
x(8)
 
 
abscc_project
Project
 
x(8)
 
 
abscc_qty
Quantity
 
->>,>>>,>>9.9<<<<<<<<<
10
 
abscc_ref
Reference
 
x(24)
 
 
abscc_ship_wt
Ship Weight
 
->>,>>>,>>9.9<<<<<<<<<
10
 
abscc_ship_wt_um
Ship Weight UM
UM
x(2)
 
 
abscc_shipto
Ship-To/Dock
 
x(8)
 
 
abscc_shp_date
Ship Date
 
99/99/99
 
 
abscc_sls_acct
Sales Acct
Account
x(8)
 
 
abscc_sls_cc
Sales Cost Ctr
CC
x(4)
 
 
abscc_sls_sub
Sales Sub-Acct
Sub-Acct
x(8)
 
 
abscc_taxable
Taxable
Tax
yes/no
 
 
abscc_taxc
Tax Class
TxC
x(3)
 
 
abscc_userc01
User Field Character 1
 
x(24)
 
 
abscc_userc02
User Field Character 2
 
x(24)
 
 
oid_abscc_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
abscc_id
yes
abscc_domain
yes
no
 
 
 
abscc_abs_id
yes
no
 
 
 
abscc_abs_shipfrom
yes
no
 
abscc_inv_nbr
no
abscc_domain
yes
no
 
 
 
abscc_inv_nbr
yes
no
 
 
 
abscc_order
yes
no
 
abscc_ordln
no
abscc_domain
yes
no
 
 
 
abscc_order
yes
no
 
 
 
abscc_ord_line
yes
no
 
 
 
abscc_inv_post
yes
no
 
abscc_shipto
no
abscc_domain
yes
no
 
 
 
abscc_shipto
yes
no
 
 
 
abscc_shp_date
yes
no
 
 
 
abscc_container
yes
no
 
oid_abscc_det
yes
oid_abscc_det
yes
no
absc_det
Shipment Carrier Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
absc__qadc01
 
 
x(8)
 
 
absc_abs_id
ID
 
x(20)
 
 
absc_carrier
Carrier
 
x(8)
 
 
absc_domain
Domain
 
x(8)
 
 
absc_seq
Seq
 
>>9
 
 
absc_user1
Ufld1
 
x(8)
 
 
absc_user2
Ufld2
 
x(8)
 
 
oid_absc_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
absc_abs_id
yes
absc_domain
yes
no
 
 
 
absc_abs_id
yes
no
 
 
 
absc_seq
yes
no
 
absc_carrier
no
absc_domain
yes
no
 
 
 
absc_carrier
yes
no
 
oid_absc_det
yes
oid_absc_det
yes
no
absd_det
Shipment Line Item Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
absd__qadc02
 
 
x(24)
 
 
absd__qadc03
 
 
x(24)
 
 
absd_abs_fld_name
Shipper Field Name
 
x(32)
 
 
absd_abs_id
ID
 
x(20)
 
 
absd_domain
Domain
 
x(8)
 
 
absd_fld_name
Field Name
 
X(30)
 
 
absd_fld_prompt
Prompt for Value
 
yes/no
 
 
absd_fld_seq
Field Sequence
Seq
>>9
 
 
absd_fld_value
Field Value
 
X(30)
 
 
absd_mod_date
Modified Date
Mod Date
99/99/99
 
 
absd_mod_userid
User ID
 
x(8)
 
 
absd_shipfrom
Ship From
 
x(8)
 
 
absd_shipper_id
 
 
x(24)
 
 
absd_userc01
User Field Character 1
 
x(24)
 
 
absd_validate
Validate
 
x(24)
 
 
oid_absd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
absd_fld_name
yes
absd_domain
yes
no
 
 
 
absd_shipfrom
yes
no
 
 
 
absd_abs_id
yes
no
 
 
 
absd_fld_name
yes
no
 
absd_shipper_id
no
absd_domain
yes
no
 
 
 
absd_shipfrom
yes
no
 
 
 
absd_shipper_id
yes
no
 
 
 
absd_fld_name
yes
no
 
oid_absd_det
yes
oid_absd_det
yes
no
absi_mstr
Shipper Information Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
absi__qadc01
 
 
x(24)
 
 
absi__qadc02
 
 
x(24)
 
 
absi_abs_id
Shipper ID
Shipper
x(20)
 
 
absi_carrier_ref2
Carrier Reference 2
 
x(20)
 
 
absi_contents
Contents
 
x(60)
 
 
absi_domain
Domain
 
x(8)
 
 
absi_due_date
Due Date
Due
99/99/99
 
 
absi_mod_date
Modified Date
Mod Date
99/99/99
 
 
absi_mod_userid
User ID
 
x(8)
 
 
absi_origin
Origin
 
x(30)
 
 
absi_port_arrive
Port of Arrival
 
x(30)
 
 
absi_port_depart
Port of Departure
 
x(30)
 
 
absi_shipfrom
Ship-From
 
x(8)
 
 
absi_user1
User Field Character 1
 
x(24)
 
 
absi_user2
User Field Character 2
 
x(24)
 
 
absi_voyage
Voyage
 
x(20)
 
 
oid_absi_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
absi_abs_id
yes
absi_domain
yes
no
 
 
 
absi_shipfrom
yes
no
 
 
 
absi_abs_id
yes
no
 
oid_absi_mstr
yes
oid_absi_mstr
yes
no
absl_det
Shipment Detail Line Charges
 
 
Field Name
Label
Col-Label
Format
Dec
 
absl__qadc01
 
 
x(24)
 
 
absl__qadc02
 
 
x(24)
 
 
absl_abs_id
ID
 
x(20)
 
 
absl_abs_shipfrom
Ship From
 
x(8)
 
 
absl_acct
Trailer Acct
Account
x(8)
 
 
absl_cc
Trailer CC
CC
x(4)
 
 
absl_charge_type
Charge Type
Charge!Type
x(8)
 
 
absl_confirmed
Confirmed
 
yes/no
 
 
absl_domain
Domain
 
x(8)
 
 
absl_ext_price
Extended Charge
 
->>>>,>>>,>>9.99<<<
10
 
absl_inv_nbr
Invoice Number
 
x(22)
 
 
absl_inv_post
Posted
 
yes/no
 
 
absl_lc_amt
Charge
 
->>>>,>>>,>>9.99<<<
10
 
absl_lc_line
Charge Line
Ln
>>9
 
 
absl_mod_date
Modified Date
Mod Date
99/99/99
 
 
absl_mod_userid
User ID
 
x(8)
 
 
absl_ord_line
SO Line
SO!Line
>>9
 
 
absl_order
Sales Order
 
x(8)
 
 
absl_project
Project
 
x(8)
 
 
absl_ref
Reference
 
x(24)
 
 
absl_sub
Trailer Sub-Acct
Sub-Acct
x(8)
 
 
absl_taxable
Taxable
 
yes/no
 
 
absl_taxc
Tax Class
TxC
x(3)
 
 
absl_trl_code
Trailer Code
Code
x(2)
 
 
absl_userc01
User Field Character 1
 
x(24)
 
 
absl_userc02
User Field Character 2
 
x(24)
 
 
oid_absl_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
absl_abs_id
yes
absl_domain
yes
no
 
 
 
absl_abs_id
yes
no
 
 
 
absl_abs_shipfrom
yes
no
 
 
 
absl_order
yes
no
 
 
 
absl_ord_line
yes
no
 
 
 
absl_lc_line
yes
no
 
absl_order
no
absl_domain
yes
no
 
 
 
absl_order
yes
no
 
 
 
absl_ord_line
yes
no
 
 
 
absl_inv_post
yes
no
 
oid_absl_det
yes
oid_absl_det
yes
no
abspli_ref
Purchase Order Shipper/Invoice Cross Reference
 
 
Field Name
Label
Col-Label
Format
Dec
 
abspli__qadc01
 
 
x(24)
 
 
abspli__qadc02
 
 
x(24)
 
 
abspli_abs_id
Shipper ID
Shipper ID
x(20)
 
 
abspli_domain
Domain
 
x(8)
 
 
abspli_mod_date
Modified Date
Mod Date
99/99/99
 
 
abspli_mod_userid
User ID
 
x(8)
 
 
abspli_pli_keyid
Key ID
 
>>>>>>>>>
 
 
abspli_supplier
Supplier
 
x(8)
 
 
abspli_user1
User Field Character 1
 
x(24)
 
 
abspli_user2
User Field Character 2
 
x(24)
 
 
oid_abspli_ref
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
abspli_primary
yes
abspli_domain
yes
no
 
 
 
abspli_supplier
yes
no
 
 
 
abspli_abs_id
yes
no
 
 
 
abspli_pli_keyid
yes
no
 
oid_abspli_ref
yes
oid_abspli_ref
yes
no
absp_det
Subshipper PO Cross Reference
 
 
Field Name
Label
Col-Label
Format
Dec
 
absp__qadc01
QAD Character Field 1
 
x(24)
 
 
absp__qadc02
QAD Character Field 2
 
x(24)
 
 
absp_mod_date
Modified Date
Mod Date
99/99/99
 
 
absp_mod_userid
User ID
 
x(8)
 
 
absp_po_nbr
Purchase Order
Order
x(8)
 
 
absp_pod_line
Line
 
>>9
 
 
absp_rcpt_qty
Receipt Qty
 
->,>>>,>>9.9<<<<<<<<
10
 
absp_user1
User Field Character 1
 
x(24)
 
 
absp_user2
User Field Character 2
 
x(24)
 
 
absp_wo_lot
Cum Order ID
Cum ID
x(8)
 
 
oid_abs_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_absp_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
absp_oid_abs_mstr
yes
oid_abs_mstr
yes
no
 
 
 
absp_po_nbr
yes
no
 
 
 
absp_pod_line
yes
no
 
oid_absp_det
yes
oid_absp_det
yes
no
absr_det
Shipment Requirement Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
absr__qadc01
 
 
x(8)
 
 
absr_cnfrmd
Confirmed
 
yes/no
 
 
absr_date
Date
 
99/99/99
 
 
absr_domain
Domain
 
x(8)
 
 
absr_id
Id
 
x(8)
 
 
absr_interval
Interval
 
x(1)
 
 
absr_line
Line
Ln
>>9
 
 
absr_nbr
Order
Sls Order
x(8)
 
 
absr_qty
Qty Pegged
 
>,>>>,>>9.9<<<<
10
 
absr_reference
Reference
 
x(24)
 
 
absr_rlse_id
Release ID
 
x(30)
 
 
absr_ship_id
ID
 
x(8)
 
 
absr_shipfrom
Ship-from Id
 
x(8)
 
 
absr_time
Time
 
99:99
 
 
absr_type
Schedule Type
 
>9
 
 
absr_user1
Ufld1
 
x(8)
 
 
absr_user2
Ufld2
 
x(8)
 
 
oid_absr_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
absr_dtl
yes
absr_domain
yes
no
 
 
 
absr_shipfrom
yes
no
 
 
 
absr_id
yes
no
 
 
 
absr_type
yes
no
 
 
 
absr_nbr
yes
no
 
 
 
absr_line
yes
no
 
 
 
absr_rlse_id
yes
no
 
 
 
absr_date
yes
no
 
 
 
absr_time
yes
no
 
 
 
absr_interval
yes
no
 
 
 
absr_reference
yes
no
 
absr_nbr
no
absr_domain
yes
no
 
 
 
absr_cnfrmd
yes
no
 
 
 
absr_type
yes
no
 
 
 
absr_nbr
yes
no
 
 
 
absr_line
yes
no
 
 
 
absr_rlse_id
yes
no
 
 
 
absr_date
yes
no
 
 
 
absr_time
yes
no
 
 
 
absr_interval
yes
no
 
 
 
absr_reference
yes
no
 
oid_absr_det
yes
oid_absr_det
yes
no
abssc_det
Shipper Validation Error Log
 
 
Field Name
Label
Col-Label
Format
Dec
 
abssc__qadc01
 
 
x(24)
 
 
abssc__qadc02
 
 
x(24)
 
 
abssc_abs_id
Shipper ID
 
x(20)
 
 
abssc_abs_item
Item
 
x(18)
 
 
abssc_abs_shipfrom
Ship-From
 
x(8)
 
 
abssc_container_id
Container ID
 
x(8)
 
 
abssc_create_date
Create Date
 
99/99/99
 
 
abssc_create_time
Create Time
 
>>>>>>>9
 
 
abssc_create_userid
User ID
 
x(8)
 
 
abssc_domain
Domain
 
x(8)
 
 
abssc_fld_value
Field Value
 
x(30)
 
 
abssc_flddesc
Field Description
 
x(40)
 
 
abssc_fldname
Fieldname
 
x(30)
 
 
abssc_line
Line
 
x(8)
 
 
abssc_line_abs_id
Line Abs Id
 
x(20)
 
 
abssc_mod_date
Modified Date
Mod Date
99/99/99
 
 
abssc_mod_userid
User ID
 
x(8)
 
 
abssc_msglevel
Message Level
 
9
 
 
abssc_msgnum
Message Number
 
>>>>9
 
 
abssc_order
Order
 
x(8)
 
 
abssc_resolved
Resolved
 
yes/no
 
 
abssc_resolved_date
Resolved Date
 
99/99/99
 
 
abssc_resolved_time
Resolved Time
 
>>>>>>>9
 
 
abssc_resolved_userid
User ID
 
x(8)
 
 
abssc_shphv_val_arg1
Message Argument
 
x(22)
 
 
abssc_shphvpv_location
Location
 
x(22)
 
 
abssc_user1
User Field Character 1
 
x(24)
 
 
abssc_user2
User Field Character 2
 
x(24)
 
 
abssc_val_msg1
Message
 
x(45)
 
 
abssc_val_msg2
Message
 
x(75)
 
 
oid_abssc_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_shphv_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
abssc_abs_id
yes
abssc_domain
yes
no
 
 
 
abssc_abs_shipfrom
yes
no
 
 
 
abssc_abs_id
yes
no
 
 
 
abssc_line_abs_id
yes
no
 
 
 
abssc_fldname
yes
no
 
 
 
abssc_msgnum
yes
no
 
 
 
abssc_msglevel
yes
no
 
abssc_resolved
no
abssc_domain
yes
no
 
 
 
abssc_resolved
yes
no
 
 
 
abssc_abs_shipfrom
yes
no
 
 
 
abssc_create_date
yes
no
 
 
 
abssc_abs_id
yes
no
 
oid_abssc_det
yes
oid_abssc_det
yes
no
abssi_det
Shipment Signature Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
abssi__qadc01
 
 
x(24)
 
 
abssi__qadc02
 
 
x(24)
 
 
abssi_abs_id
Shipper ID
 
x(20)
 
 
abssi_certificate
Shipment Certificate
 
x(16)
 
 
abssi_create_date
Creation Date
 
99/99/9999
 
 
abssi_create_time
Creation Time
 
x(10)
 
 
abssi_curr_signature
Signature Current Shipment
 
x(256)
 
 
abssi_domain
Domain
 
x(8)
 
 
abssi_key
Certification Key
 
x(128)
 
 
abssi_mod_date
Modified date
Mod Date
99/99/99
 
 
abssi_mod_userid
User ID
 
x(8)
 
 
abssi_prev_signature
Signature Previous Shipment
 
x(256)
 
 
abssi_short_signature
Short Signature
 
x(4)
 
 
abssi_status
Status
 
x(10)
 
 
abssi_user1
User Field Character 1
 
x(24)
 
 
abssi_user2
User Field Character 2
 
x(24)
 
 
abssi_version
Version
 
x(8)
 
 
oid_abs_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_abssi_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 ∗
oid_abs_mstr
no
oid_abs_mstr
yes
no
 
oid_abssi_det
yes
oid_abssi_det
yes
no
abss_det
Shipment Sequence Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
abss__qadc01
 
 
x(8)
 
 
abss__qadc02
 
 
x(8)
 
 
abss__qadd01
 
 
->,>>>,>>9.9<<<<<<<<
10
 
abss__qadd02
 
 
->,>>>,>>9.9<<<<<<<<
10
 
abss__qadi01
 
 
->,>>>,>>9
 
 
abss__qadi02
 
 
->,>>>,>>9
 
 
abss__qadl01
 
 
yes/no
 
 
abss__qadl02
 
 
yes/no
 
 
abss__qadt01
 
 
99/99/99
 
 
abss__qadt02
 
 
99/99/99
 
 
abss_abs_id
ID
 
x(20)
 
 
abss_confirmed
Confirmed
 
yes/no
 
 
abss_cust_job
Customer Job
 
x(30)
 
 
abss_cust_ref
Customer Reference
 
x(30)
 
 
abss_cust_seq
Customer Sequence
 
x(30)
 
 
abss_date
Schedule Date
Date
99/99/99
 
 
abss_dock
Customer Dock
 
x(30)
 
 
abss_domain
Domain
 
x(8)
 
 
abss_invoice
Invoice
 
x(8)
 
 
abss_line
Line
 
>>9
 
 
abss_line_feed
Line Feed
 
x(30)
 
 
abss_mod_date
Modified Date
Mod Date
99/99/99
 
 
abss_mod_pgm
Last Program
 
x(8)
 
 
abss_mod_userid
User ID
 
x(8)
 
 
abss_order
Order
 
x(8)
 
 
abss_part
Item Number
 
x(18)
 
 
abss_qty
Quantity
 
>>,>>>,>>9.9<<<<<<<<<
10
 
abss_rlse_id
Release ID
 
x(30)
 
 
abss_ship_id
Ship ID
 
x(20)
 
 
abss_shipfrom
Ship-From
 
x(8)
 
 
abss_shipto
Ship-To
 
x(8)
 
 
abss_status
Status
 
x(8)
 
 
abss_time
Schedule Time
Time
99:99
 
 
abss_user1
Ufld1
 
x(8)
 
 
abss_user2
Ufld2
 
x(8)
 
 
oid_abss_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
abss_index1
yes
abss_domain
yes
no
 
 
 
abss_abs_id
yes
no
 
 
 
abss_shipfrom
yes
no
 
 
 
abss_shipto
yes
no
 
 
 
abss_rlse_id
yes
no
 
 
 
abss_cust_job
yes
no
 
 
 
abss_cust_seq
yes
no
 
 
 
abss_part
yes
no
 
 
 
abss_date
yes
no
 
 
 
abss_time
yes
no
 
 
 
abss_cust_ref
yes
no
 
 
 
abss_dock
yes
no
 
 
 
abss_line_feed
yes
no
 
abss_index2
no
abss_domain
yes
no
 
 
 
abss_shipfrom
yes
no
 
 
 
abss_shipto
yes
no
 
 
 
abss_rlse_id
yes
no
 
 
 
abss_cust_ref
yes
no
 
 
 
abss_part
yes
no
 
abss_index3
no
abss_domain
yes
no
 
 
 
abss_ship_id
yes
no
 
 
 
abss_part
yes
no
 
 
 
abss_cust_job
yes
no
 
 
 
abss_cust_seq
yes
no
 
abss_index4
no
abss_domain
yes
no
 
 
 
abss_ship_id
yes
no
 
 
 
abss_date
yes
no
 
 
 
abss_time
yes
no
 
 
 
abss_cust_job
yes
no
 
 
 
abss_cust_seq
yes
no
 
 
 
abss_part
yes
no
 
abss_index5
no
abss_domain
yes
no
 
 
 
abss_ship_id
yes
no
 
 
 
abss_order
yes
no
 
 
 
abss_line
yes
no
 
abss_index6
no
abss_domain
yes
no
 
 
 
abss_invoice
yes
no
 
 
 
abss_order
yes
no
 
 
 
abss_line
yes
no
 
abss_index7
no
abss_domain
yes
no
 
 
 
abss_invoice
yes
no
 
 
 
abss_cust_job
yes
no
 
 
 
abss_cust_seq
yes
no
 
 
 
abss_part
yes
no
 
oid_abss_det
yes
oid_abss_det
yes
no
absw_det
ABS Lot/Serial Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
absw__qadc01
QAD Character Field 1
 
x(24)
 
 
absw__qadc02
QAD Character Field 2
 
x(24)
 
 
absw_lotser
Lot/Serial
 
x(18)
 
 
absw_mod_date
Modified Date
Mod Date
99/99/99
 
 
absw_mod_userid
User ID
 
x(8)
 
 
absw_rcpt_qty
Receipt Qty
 
>,>>>,>>9.9<<<<<<<<
10
 
absw_receipt_date
Receipt Date
 
99/99/99
 
 
absw_receipt_time
Arrive Time
 
>>>>>>>9
 
 
absw_ref
Reference
Ref
x(8)
 
 
absw_scrap_qty
Scrap Qty
 
>,>>>,>>9.9<<<<<<<<
10
 
absw_ship_qty
Quantity Shipped
Quantity!Shipped
>,>>>,>>9.9<<<<<<<<
10
 
absw_user1
User Field Character 1
 
x(24)
 
 
absw_user2
User Field Character 2
 
x(24)
 
 
oid_abs_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_absw_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
absw_oid_abs_mstr
yes
oid_abs_mstr
yes
no
 
 
 
absw_lotser
yes
no
 
 
 
absw_ref
yes
no
 
oid_absw_det
yes
oid_absw_det
yes
no
absx_det
Subcontract Shipper PO Shipper Cross Reference
 
 
Field Name
Label
Col-Label
Format
Dec
 
absx__qadc01
QAD Character Field 1
 
x(24)
 
 
absx__qadc02
QAD Character Field 2
 
x(24)
 
 
absx_comment
Comment Index
 
>>>>>>>>
 
 
absx_complete
Close Sub Shipper
Close!Sub Shipper
yes/no
 
 
absx_domain
Domain
 
x(8)
 
 
absx_lotser
Lot/Serial
 
x(18)
 
 
absx_mod_date
Modified Date
Mod Date
99/99/99
 
 
absx_mod_userid
User ID
 
x(8)
 
 
absx_part
Item Number
 
x(18)
 
 
absx_po_nbr
Purchase Order
Order
x(8)
 
 
absx_po_shipper
PO Shipper
 
x(20)
 
 
absx_pod_line
Line
 
>>9
 
 
absx_qty_to_receive
Qty To Receive
 
->,>>>,>>9.9<<<<<<<<
10
 
absx_qty_to_scrap
Qty To Scrap
 
->,>>>,>>9.9<<<<<<<<
10
 
absx_ref
Reference
Ref
x(8)
 
 
absx_return
Return
 
yes/no
 
 
absx_user1
User Field Character 1
 
x(24)
 
 
absx_user2
User Field Character 2
 
x(24)
 
 
oid_abs_subcontract
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_absx_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
absx_oid_abs_mstr
yes
oid_abs_subcontract
yes
no
 
 
 
absx_domain
yes
no
 
 
 
absx_part
yes
no
 
 
 
absx_lotser
yes
no
 
 
 
absx_ref
yes
no
 
 
 
absx_po_shipper
yes
no
 
absx_po
no
absx_domain
yes
no
 
 
 
absx_po_shipper
yes
no
 
 
 
absx_po_nbr
yes
no
 
 
 
absx_pod_line
yes
no
 
 
 
absx_lotser
yes
no
 
 
 
absx_ref
yes
no
 
oid_absx_det
yes
oid_absx_det
yes
no
abs_mstr
ASN/BOL/Shipper Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
abs__chr01
 
 
x(8)
 
 
abs__chr02
 
 
x(8)
 
 
abs__chr03
 
 
x(8)
 
 
abs__chr04
 
 
x(8)
 
 
abs__chr05
 
 
x(8)
 
 
abs__chr06
 
 
x(8)
 
 
abs__chr07
 
 
x(8)
 
 
abs__chr08
 
 
x(8)
 
 
abs__chr09
 
 
x(8)
 
 
abs__chr10
 
 
x(8)
 
 
abs__dec01
 
 
>>>,>>>,>>9.99
10
 
abs__dec02
 
 
>>>,>>>,>>9.99
10
 
abs__dec03
 
 
>>>,>>>,>>9.99
10
 
abs__dec04
 
 
>>>,>>>,>>9.99
10
 
abs__dec05
 
 
>>>,>>>,>>9.99
10
 
abs__dec06
 
 
>>>,>>>,>>9.99
10
 
abs__dec07
 
 
>>>,>>>,>>9.99
10
 
abs__dec08
 
 
>>>,>>>,>>9.99
10
 
abs__dec09
 
 
>>>,>>>,>>9.99
10
 
abs__dec10
 
 
>>>,>>>,>>9.99
10
 
abs__qad01
 
 
x(8)
 
 
abs__qad02
 
 
x(8)
 
 
abs__qad03
 
 
x(8)
 
 
abs__qad04
 
 
x(8)
 
 
abs__qad05
 
 
x(8)
 
 
abs__qad06
 
 
x(8)
 
 
abs__qad07
 
 
x(8)
 
 
abs__qad08
 
 
x(8)
 
 
abs__qad09
 
 
x(8)
 
 
abs__qad10
 
 
x(8)
 
 
abs__qadc01
 
 
x(8)
 
 
abs__qadc02
 
 
x(24)
 
 
abs__qadc03
 
 
x(24)
 
 
abs__qadd01
 
 
>,>>>,>>9.9<<<<<<<<
10
 
abs__qadi01
 
 
->>>>>>>9
 
 
abs__qadl01
 
 
yes/no
 
 
abs__qadt01
 
 
99/99/99
 
 
abs_acct
Account
Acct
x(8)
 
 
abs_act_fcst
Act Frt Cost
 
>>>>,>>>,>>9.99
10
 
abs_act_qty
Actual Qty
 
->>,>>>,>>9.9<<<<<<<<<
10
 
abs_apr_date
Approval Date
 
99/99/99
 
 
abs_apr_time
Approval Time
 
>>>>>>>9
 
 
abs_apr_userid
Approved By
 
x(8)
 
 
abs_arr_date
Arrive Date
 
99/99/99
 
 
abs_arr_time
Arrive Time
 
>>>>>>>9
 
 
abs_asn_crt_date
ASN Create Date
 
99/99/99
 
 
abs_asn_crt_time
ASN Create Time
 
>>>>>>>9
 
 
abs_bom_code
BOM/Formula
 
x(18)
 
 
abs_bulk_qty
Actual Bulk Qty
 
->>,>>>,>>9.9<<<<<<<<<
10
 
abs_cancel_date
Cancel Date
 
99/99/99
 
 
abs_canceled
Canceled
 
Yes/No
 
 
abs_cc
Cost Center
CC
x(4)
 
 
abs_charge_type
Charge Type
Charge!Type
x(8)
 
 
abs_cmtindx
Comment Index
 
>>>>>>>9
 
 
abs_combined_invoice
Combined Invoice
 
yes/no
 
 
abs_complete
Complete
 
yes/no
 
 
abs_cons_ship
Consolidate
 
x(8)
 
 
abs_consigned_return
Consigned Return
 
yes/no
 
 
abs_crt_date
Create Date
 
99/99/99
 
 
abs_crt_time
Create Time
 
>>>>>>>9
 
 
abs_cum_qty
Cum Ship Qty
 
>,>>>,>>9.9<<<<<<<<
10
 
abs_cust_ref
Customer Ref
 
x(24)
 
 
abs_dataset
Data Set
 
x(12)
 
 
abs_desc
Description
 
x(48)
 
 
abs_dim_um
Dimensions UM
 
x(2)
 
 
abs_doc_data[5]
 
 
x(8)
 
 
abs_domain
Domain
 
x(8)
 
 
abs_eff_date
Effective
 
99/99/99
 
 
abs_est_fcst
Est Frt Cost
 
>>>>,>>>,>>9.99
10
 
abs_export_batch
Batch
 
>>>>>>>>9
 
 
abs_export_date
Export Date
 
99/99/99
 
 
abs_export_time
Export Time
 
>>>>>>>9
 
 
abs_fa_lot
Final Assembly ID
ID
x(8)
 
 
abs_format
Document Format
Format
x(8)
 
 
abs_fr_class
Frt Class
 
x(8)
 
 
abs_fr_curr
Currency
 
x(3)
 
 
abs_gwt
Gross Weight
 
>,>>>,>>9.9<<<<<<<<
10
 
abs_id
Id
 
x(20)
 
 
abs_inv_mov
Inventory Movement Code
Inv Mov
x(8)
 
 
abs_inv_nbr
Invoice Number
 
x(22)
 
 
abs_item
Container Item
 
x(18)
 
 
abs_lang
Language
 
x(2)
 
 
abs_line
Order Line
 
x(8)
 
 
abs_loc
Location
 
x(8)
 
 
abs_lotser
Lot/Serial
 
x(18)
 
 
abs_master_id
Master Bill ID
 
x(20)
 
 
abs_master_shipfrom
Master Bill Ship-From
MBOL!ShipFrom
x(8)
 
 
abs_nr_id
Sequence ID
 
x(8)
 
 
abs_nwt
Net Weight
 
>,>>>,>>9.9<<<<<<<<
10
 
abs_order
Order
 
x(8)
 
 
abs_par_id
Parent ID
 
x(24)
 
 
abs_preship_id
Pre-Shipper Number
 
x(20)
 
 
abs_preship_nr_id
Pre-Shipper Sequence ID
 
x(8)
 
 
abs_price
Price
 
->>>>,>>>,>>9.99<<<
10
 
abs_production_line
Production Line
Line
x(8)
 
 
abs_proj
Project
 
x(8)
 
 
abs_qty
Qty To Ship
 
>,>>>,>>9.9<<<<<<<<
10
 
abs_rcpt_qty
Receipt Qty
 
>,>>>,>>9.9<<<<<<<<
10
 
abs_ref
Ref
 
x(8)
 
 
abs_routing
Routing Code
 
x(18)
 
 
abs_scrap_qty
Scrap Qty
 
>,>>>,>>9.9<<<<<<<<
10
 
abs_ship_qty
Quantity Shipped
 
>,>>>,>>9.9<<<<<<<<
10
 
abs_ship_type
Ship Type
T
x(1)
 
 
abs_shipfrom
Ship-from Id
 
x(8)
 
 
abs_shipto
Ship-to Id
 
x(8)
 
 
abs_shp_date
Ship Date
 
99/99/99
 
 
abs_shp_time
Ship Time
 
>>>>>>>9
 
 
abs_site
Site
 
x(8)
 
 
abs_status
Status
 
x(8)
 
 
abs_sub
Sub-Account
Sub-Acct
x(8)
 
 
abs_tax_env
Tax Environment
 
x(16)
 
 
abs_tax_in
Tax In
 
yes/no
 
 
abs_tax_usage
Tax Usage
 
x(8)
 
 
abs_taxable
Taxable
 
yes/no
 
 
abs_taxc
Tax Class
 
x(3)
 
 
abs_timezone
Time Zone
 
x(2)
 
 
abs_trl_cmtindx
Trailer Comments
 
>>>>>>>9
 
 
abs_type
Type
 
x(1)
 
 
abs_user1
Ufld1
 
x(8)
 
 
abs_user2
Ufld2
 
x(8)
 
 
abs_vend_lot
Supplier Lot
 
x(18)
 
 
abs_vol
Volume
 
>,>>>,>>9.9<<<<<<<<
10
 
abs_vol_um
Volume UM
 
x(2)
 
 
abs_wt_um
Weight UM
 
x(2)
 
 
oid_abs_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_lgdd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
abs_export_batch
no
abs_domain
yes
no
 
 
 
abs_export_batch
yes
no
 
abs_format
no
abs_domain
yes
no
 
 
 
abs_format
yes
no
abs_id
yes
abs_domain
yes
no
 
 
 
abs_shipfrom
yes
no
 
 
 
abs_id
yes
no
 
abs_inv_mov
no
abs_domain
yes
no
 
 
 
abs_inv_mov
yes
no
 
abs_inv_nbr
no
abs_domain
yes
no
 
 
 
abs_inv_nbr
yes
no
 
 
 
abs_shipfrom
yes
no
 
 
 
abs_id
yes
no
 
abs_item
no
abs_domain
yes
no
 
 
 
abs_item
yes
no
 
 
 
abs_shipfrom
yes
no
 
abs_master_id
no
abs_domain
yes
no
 
 
 
abs_master_id
yes
no
 
 
 
abs_master_shipfrom
yes
no
 
 
 
abs_shipfrom
yes
no
 
abs_order
no
abs_domain
yes
no
 
 
 
abs_order
yes
no
 
abs_par_id
yes
abs_domain
yes
no
 
 
 
abs_shipfrom
yes
no
 
 
 
abs_par_id
yes
no
 
 
 
abs_id
yes
no
 
abs_shipto
yes
abs_domain
yes
no
 
 
 
abs_shipfrom
yes
no
 
 
 
abs_shipto
yes
no
 
 
 
abs_id
yes
no
 
oid_abs_mstr
yes
oid_abs_mstr
yes
no
 
oid_lgdd_det
no
oid_lgdd_det
yes
no
AcctIF
Chinese Accounting Interface
 
 
Field Name
Label
Col-Label
Format
Dec
 
AcctIF_ID
Record ID
 
-99999999999
 
 
AcctIFCode
Code
 
x(20)
 
 
AcctIFExportFileName
Export File Name
 
x(40)
 
 
AcctIFIsExport
Export
 
yes/no
 
 
AcctIFLastExportDate
Last Export Date
 
99/99/9999
 
 
AcctIFName
Report Name
 
x(40)
 
 
AcctIFStatus
Status
 
x(40)
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
Usr_ID
User Name
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 ∗
Prim
yes
AcctIF_ID
yes
no
 
UniqueIdx
yes
AcctIFCode
yes
no
 
UsrIdx
no
Usr_ID
yes
no
AcctIFFilter
Chinese Accounting Interface Filter
 
 
Field Name
Label
Col-Label
Format
Dec
 
AcctIFFilter_ID
Record ID
 
-99999999999
 
 
AcctIFFilterAcctBookNo
Accounting Book No
Book No
x(40)
 
 
AcctIFFilterAcctFromDate
Measure1 from Date
 
99/99/9999
 
 
AcctIFFilterAcctFromDate2
Measure2 from Date
 
99/99/9999
 
 
AcctIFFilterAcctLevel
Account Code Structure
Acc Code Structure
x(40)
 
 
AcctIFFilterAcctToDate
Measure1 to Date
 
99/99/9999
 
 
AcctIFFilterAcctToDate2
Measure2 to Date
 
99/99/9999
 
 
AcctIFFilterAltCOALevel
Alternate COA Level
 
->,>>>,>>9
 
 
AcctIFFilterBudgetLevel
Budget Level
 
9
 
 
AcctIFFilterCOACrossRef
COA Cross Reference
 
x(20)
 
 
AcctIFFilterFiscalYear
Fiscal Year
 
x(4)
 
 
AcctIFFilterIndustry
Industry
 
x(40)
 
 
AcctIFFilterLayerCode
Layer Code
 
x(200)
 
 
AcctIFFilterOrgCode
Organization Code
Org Code
x(40)
 
 
AcctIFFilterStructCodeBS
Balance Sheet Structure Code
Balance Sheet
x(40)
 
 
AcctIFFilterStructCodeIS
Income statement Structure Code
Income Statement
x(40)
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 ∗
Prim
yes
AcctIFFilter_ID
yes
no
 
UniqueIdx
yes
AcctIFFilterAcctLevel
yes
no
 
 
 
AcctIFFilterIndustry
yes
no
 
 
 
AcctIFFilterOrgCode
yes
no
 
 
 
AcctIFFilterFiscalYear
yes
no
 
 
 
AcctIFFilterAcctBookNo
yes
no
 
 
 
AcctIFFilterAcctFromDate
yes
no
 
 
 
AcctIFFilterAcctToDate
yes
no
 
 
 
AcctIFFilterAcctFromDate2
yes
no
 
 
 
AcctIFFilterAcctToDate2
yes
no
 
 
 
AcctIFFilterBudgetLevel
yes
no
 
 
 
AcctIFFilterStructCodeIS
yes
no
 
 
 
AcctIFFilterStructCodeBS
yes
no
 
 
 
AcctIFFilterLayerCode
yes
no
acdf_mstr
Account Default Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
acdf__qadc01
 
 
x(24)
 
 
acdf__qadd01
 
 
->>>>,>>>,>>9.99<<<<<<<<<
10
 
acdf__qadi01
 
 
->>>>>>>9
 
 
acdf__qadl01
 
 
yes/no
 
 
acdf__qadt01
 
 
99/99/99
 
 
acdf_acct
Account Number
Account
x(8)
 
 
acdf_cc
Cost Center
CC
x(4)
 
 
acdf_domain
Domain
 
x(8)
 
 
acdf_key1
 
 
x(20)
 
 
acdf_key2
 
 
x(8)
 
 
acdf_key3
 
 
x(8)
 
 
acdf_key4
 
 
x(8)
 
 
acdf_key5
 
 
x(8)
 
 
acdf_key6
 
 
x(8)
 
 
acdf_mod_date
Modified Date
Mod Date
99/99/99
 
 
acdf_mod_userid
User ID
 
x(8)
 
 
acdf_module
Module
 
x(2)
 
 
acdf_sub
Sub Account
Sub Acct
x(8)
 
 
acdf_type
Account Type
 
x(24)
 
 
acdf_userc01
User field Character 1
 
x(24)
 
 
acdf_userc02
User field character 2
 
x(24)
 
 
acdf_userd01
User field Decimal
 
->>>>,>>>,>>9.99<<<<<<<<<
10
 
acdf_useri01
User field integer
 
->>>>>>>9
 
 
acdf_userl01
User field logical
 
yes/no
 
 
acdf_usert01
User field Date
 
99/99/99
 
 
oid_acdf_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
acdf_index1
yes
acdf_domain
yes
no
 
 
 
acdf_module
yes
no
 
 
 
acdf_type
yes
no
 
 
 
acdf_key1
yes
no
 
 
 
acdf_key2
yes
no
 
 
 
acdf_key3
yes
no
 
 
 
acdf_key4
yes
no
 
 
 
acdf_key5
yes
no
 
 
 
acdf_key6
yes
no
 
oid_acdf_mstr
yes
oid_acdf_mstr
yes
no
acld_det
Attribute Category Link Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
acld__qadc01
 
 
x(24)
 
 
acld__qadc02
 
 
x(24)
 
 
acld_active
Active
 
yes/no
 
 
acld_allow_mod
Allow Modification
Allow Mod
yes/no
 
 
acld_cat
Category
 
x(18)
 
 
acld_domain
Domain
 
x(8)
 
 
acld_label_term
Label Term
 
x(35)
 
 
acld_mod_date
Modified Date
Mod Date
99/99/99
 
 
acld_mod_userid
User ID
 
x(8)
 
 
acld_name
Attribute Name
 
x(32)
 
 
acld_req
Required
 
yes/no
 
 
acld_system
System
 
yes/no
 
 
acld_user1
User Field Character 1
 
x(24)
 
 
acld_user2
User Field Character 2
 
x(24)
 
 
oid_acld_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
acld_cat
yes
acld_cat
yes
no
 
 
 
acld_name
yes
no
 
 
 
acld_domain
yes
no
 
acld_name_domain
no
acld_name
yes
no
 
 
 
acld_domain
yes
no
 
oid_acld_det
yes
oid_acld_det
yes
no
acm_mstr
Co-product/By-product Average Cost Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
acm__qadc01
 
 
x(8)
 
 
acm_domain
Domain
 
x(8)
 
 
acm_method
Method
 
x(14)
 
 
acm_part
Base Process
 
x(18)
 
 
acm_prod_line
Product Line
 
x(4)
 
 
acm_site
Site
 
x(8)
 
 
acm_user1
Ufld1
 
x(8)
 
 
acm_user2
Ufld2
 
x(8)
 
 
oid_acm_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
acm_index
no
acm_domain
yes
no
 
 
 
acm_site
yes
no
 
 
 
acm_prod_line
yes
no
 
 
 
acm_part
yes
no
 
acm_unique
yes
acm_domain
yes
no
 
 
 
acm_site
yes
no
 
 
 
acm_prod_line
yes
no
 
 
 
acm_part
yes
no
 
 
 
acm_method
yes
no
 
oid_acm_mstr
yes
oid_acm_mstr
yes
no
actf_mstr
Info on table and related account, sub-account, cc field names
 
 
Field Name
Label
Col-Label
Format
Dec
 
actf__qadc01
 
 
x(24)
 
 
actf__qadc02
 
 
x(24)
 
 
actf_acct_fldname
Account Field Name
Account!Field Name
x(32)
 
 
actf_cc_fldname
Cost Center Field Name
Cost Center!Field Name
x(32)
 
 
actf_exec
Execution File
Exec File
x(16)
 
 
actf_mod_date
Modified Date
Mod Date
99/99/99
 
 
actf_mod_userid
User ID
 
x(8)
 
 
actf_proj_fldname
Project Field Name
Project!Field Name
x(32)
 
 
actf_sub_fldname
Sub-Account Field Name
Sub-Account!Field Name
x(32)
 
 
actf_tblname
Table Name
Table!Name
x(16)
 
 
actf_user1
User Field Character 1
 
x(24)
 
 
actf_user2
User Field Character 2
 
x(24)
 
 
oid_actf_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
actf_tbl_acctfld
yes
actf_tblname
yes
no
 
 
 
actf_exec
yes
no
 
 
 
actf_acct_fldname
yes
no
 
oid_actf_mstr
yes
oid_actf_mstr
yes
no