QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
cas_mstr
Service/Support Call Status Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
cas__chr01
 
 
x(8)
 
 
cas__chr02
 
 
x(8)
 
 
cas__chr03
 
 
x(8)
 
 
cas__dec01
 
 
->>,>>9.99
10
 
cas__dec02
 
 
->>,>>9.99
10
 
cas__dte01
 
 
99/99/99
 
 
cas__dte02
 
 
99/99/99
 
 
cas__log01
 
 
yes/no
 
 
cas__log02
 
 
yes/no
 
 
cas__qadc01
QAD Character Field 1
 
X(8)
 
 
cas__qadc02
QAD Character Field 2
 
X(8)
 
 
cas__qadl01
QAD Logical Field 1
 
yes/no
 
 
cas__qadl02
QAD Logical Field 2
 
yes/no
 
 
cas_desc
Description
 
x(24)
 
 
cas_domain
Domain
 
x(8)
 
 
cas_field
Field
Fld
yes/no
 
 
cas_file_type
 
 
x(3)
 
 
cas_hold
Hold
 
yes/no
 
 
cas_id
Status ID
Sts Id
>>9
 
 
cas_mod_date
Modified Date
Mod Date
99/99/99
 
 
cas_mod_userid
User ID
 
X(8)
 
 
cas_nxt_que
Next Queue
 
x(8)
 
 
cas_nxt_stat
Next Status
Nxt Sts
x(8)
 
 
cas_prog
Program To Invoke
Program
x(12)
 
 
cas_req
Required
Req
yes/no
 
 
cas_review
Review
 
yes/no
 
 
cas_status
Status
 
x(8)
 
 
cas_user1
Ufld1
 
x(8)
 
 
cas_user2
Ufld2
 
x(8)
 
 
cas_wait
Waiting for Items
 
yes/no
 
 
oid_cas_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
cas_id
yes
cas_domain
yes
no
 
 
 
cas_id
yes
no
 
 
 
cas_file_type
yes
no
cas_status
yes
cas_domain
yes
no
 
 
 
cas_status
yes
no
 
 
 
cas_file_type
yes
no
 
oid_cas_mstr
yes
oid_cas_mstr
yes
no
categ_mstr
Category Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
categ__qadc01
 
 
x(24)
 
 
categ__qadc02
 
 
x(24)
 
 
categ_active
Active
 
yes/no
 
 
categ_cat
Category
 
x(18)
 
 
categ_desc
Description
 
x(24)
 
 
categ_fnc
Function Name
Function
x(20)
 
 
categ_label_term
Label Term
 
x(35)
 
 
categ_mod_date
Modified Date
Mod Date
99/99/99
 
 
categ_mod_userid
User ID
 
x(8)
 
 
categ_system
System
 
yes/no
 
 
categ_user1
User Field Character 1
 
x(24)
 
 
categ_user2
User Field Character 2
 
x(24)
 
 
oid_categ_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
categ_cat
yes
categ_cat
yes
no
 
 
 
categ_fnc
yes
no
 
categ_fnc
no
categ_fnc
yes
no
 
 
 
categ_cat
yes
no
 
oid_categ_mstr
yes
oid_categ_mstr
yes
no
ca_mstr
Service/Support Call Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
ca__chr01
 
 
x(8)
 
 
ca__chr02
 
 
x(8)
 
 
ca__chr03
 
 
x(8)
 
 
ca__chr04
 
 
x(8)
 
 
ca__chr05
 
 
x(8)
 
 
ca__chr06
 
 
x(8)
 
 
ca__chr07
 
 
x(8)
 
 
ca__chr08
 
 
x(8)
 
 
ca__chr09
 
 
x(8)
 
 
ca__chr10
 
 
x(8)
 
 
ca__dec01
 
 
->>,>>9.99
10
 
ca__dec02
 
 
->>,>>9.99
10
 
ca__dec03
 
 
->>,>>9.99
10
 
ca__dte01
 
 
99/99/99
 
 
ca__dte02
 
 
99/99/99
 
 
ca__dte03
 
 
99/99/99
 
 
ca__dte04
 
 
99/99/99
 
 
ca__dte05
 
 
99/99/99
 
 
ca__log01
 
 
yes/no
 
 
ca__log02
 
 
yes/no
 
 
ca__log03
 
 
yes/no
 
 
ca__log04
 
 
yes/no
 
 
ca__log05
 
 
yes/no
 
 
ca__qadc03
QAD Character Field 3
 
X(8)
 
 
ca__qadc04
QAD Character Field 4
 
x(8)
 
 
ca__qadc05
QAD Character Field 5
 
x(8)
 
 
ca__qadc06
QAD Character Field 6
 
x(8)
 
 
ca__qadd01
QAD Decimal Field 1
 
->>,>>9.99
10
 
ca__qadd02
QAD Decimal Field 2
 
->>,>>9.99
10
 
ca__qadd03
QAD Decimal Field 3
 
->>,>>9.99
10
 
ca__qadi01
 
 
>>>>>>>9
 
 
ca__qadi02
QAD Integer Field 2
 
->,>>>,>>9
 
 
ca__qadi03
QAD Integer Field 3
 
->,>>>,>>9
 
 
ca__qadl02
QAD Logical Field 2
 
yes/no
 
 
ca__qadl03
QAD Logical Field 3
 
yes/no
 
 
ca__qadl04
QAD Logical Field 4
 
yes/no
 
 
ca__qadt01
QAD Date Field 1
 
99/99/99
 
 
ca__qadt02
QAD Date Field 2
 
99/99/99
 
 
ca__qadt03
QAD Date Field 3
 
99/99/99
 
 
ca_3rd_party
Third Party Service
 
yes/no
 
 
ca_3rd_party_id
Third Party ID
 
x(12)
 
 
ca_ack_cmtindx
 
 
>>>>>>>>>>9
 
 
ca_ack_letter
Send Ack Letter
 
yes/no
 
 
ca_activity
Activity
 
yes/no
 
 
ca_area
Area
 
x(8)
 
 
ca_assign
Assigned
 
x(8)
0
 
ca_bill
Bill-To
 
x(8)
 
 
ca_billed
Billed
 
yes/no
 
 
ca_category
Category
 
x(8)
 
 
ca_channel
Channel
 
X(8)
0
 
ca_cline
Contract Line
 
>>>>>>>9
 
 
ca_cls_date
Date Closed
 
99/99/99
 
 
ca_cls_time
Close Time
 
99:99
 
 
ca_cmmt_mod
Comments Modified
Cmt
yes/no
 
 
ca_cmtindx
Index
 
>>>>>>>9
 
 
ca_code
 
 
x(8)
 
 
ca_comp_date
Complete Date
 
99/99/99
 
 
ca_comp_time
Complete Time
 
99:99
 
 
ca_contract
Contract
 
x(8)
 
 
ca_cr_terms
Terms
 
x(8)
 
 
ca_created
Created
Cr
x(1)
0
 
ca_curr
Currency
Cur
x(3)
 
 
ca_customer
Customer
 
X(8)
 
 
ca_date_stmp
Date
 
99/99/99
 
 
ca_daybookset
Daybook Set
Dybk Set
x(8)
 
 
ca_def_ws
Default Worksheet
 
x(8)
 
 
ca_desc
Description
 
x(60)
 
 
ca_domain
Domain
 
x(8)
 
 
ca_ecmtindx
 
 
>>>>>>9
 
 
ca_end_date
End Date
 
99/99/99
 
 
ca_eng_area
Engineer Area
Eng Area
x(8)
 
 
ca_eng_group
Engineer Group
 
x(8)
 
 
ca_ent_ex
Exch Rate
 
>>,>>9.99999<<<
10
 
ca_enter_by
Entered by
 
x(8)
 
 
ca_es_nbr
Escalation
Esc
x(8)
 
 
ca_es_seq
Sequence
Seq
>>9
 
 
ca_est_time
Estimated Length
 
999:99
 
 
ca_eu_changed
End User Changed
 
yes/no
 
 
ca_eu_date
End User Date
 
99/99/99
 
 
ca_eu_nbr
End User
 
x(8)
 
 
ca_eu_time
End User Time
 
99:99
 
 
ca_evt_date
Event Date
Evt Date
99/99/99
 
 
ca_evt_tim
Event Time
Evt Time
>>>>>>9
 
 
ca_evt_time
Event Time
Evt Time
99:99
 
 
ca_ex_rate
Exch Rate
 
>>>>,>>>,>>9.9<<<<<<<<<
10
 
ca_ex_rate2
Exch Rate 2
 
>>>>,>>>,>>9.9<<<<<<<<<
10
 
ca_ex_ratetype
Rate Type
 
x(8)
 
 
ca_exru_seq
Sequence
 
>>>>>>>>9
 
 
ca_fix_rate
Fixed Rate
Fixed
yes/no
 
 
ca_fn_nbr
Field Notification
 
x(8)
 
 
ca_from_que
From Que
Fr Que
x(8)
 
 
ca_inc_stats
Include in Stats
 
yes/no
 
 
ca_int_type
Work Code
WK Code
x(8)
 
 
ca_inv_draft
 
 
yes/no
 
 
ca_lang
Language
 
x(2)
 
 
ca_mod_date
Modified Date
Mod Date
99/99/99
 
 
ca_mod_userid
User ID
 
X(8)
 
 
ca_model
Model
 
x(18)
 
 
ca_name
Caller
 
x(24)
 
 
ca_nbr
Call ID
 
x(8)
 
 
ca_nxt_act
Next Status
Nxt Sts
x(8)
0
 
ca_nxt_date
Next Status Date
Nxt Date
99/99/99
 
 
ca_nxt_tim
Next Status Time
Nxt Time
>>>>>>>>9
 
 
ca_nxt_time
Next Status Time
Time
99:99
 
 
ca_opn_date
Call Date
CL Date
99/99/99
 
 
ca_opn_time
Time Opened
Tm Open
x(8)
 
 
ca_part
Item Number
 
x(18)
 
 
ca_phone
Phone
 
x(20)
 
 
ca_po_nbr
PO
 
x(22)
 
 
ca_pr_list
Price List
 
x(8)
0
 
ca_pri
Priority
Pri
>>>9
 
 
ca_printed
Call Printed
 
yes/no
 
 
ca_prj_nbr
Project
 
x(8)
 
 
ca_problem
Prob/Skill
Prob
x(8)
 
 
ca_qo_cmtindx
 
 
>>>>>>>>>9
 
 
ca_que
Queue
 
x(8)
 
 
ca_quote
Quote Required
 
yes/no
 
 
ca_quote_exp
Expire
 
99/99/99
 
 
ca_quote_nbr
Quote Number
Quote
X(8)
 
 
ca_quote_price
Quote Price
 
>>>>,>>>,>>9.99<<<
10
 
ca_rc_site
Repair Center Site
 
x(8)
 
 
ca_recorded
 
 
yes/no
 
 
ca_ref
Ref
 
>>>>>>>9
 
 
ca_repair_ctr
 
 
yes/no
 
 
ca_res_cmtidx
 
 
>>>>>9
 
 
ca_resolve
Resolution
 
x(8)
0
 
ca_resolve_desc
Resolution
 
x(68)
0
 
ca_rev
Rev Level
Rev
x(10)
 
 
ca_rma_nbr
RMA
 
x(8)
 
 
ca_rp_bom
Bill of Material
 
x(18)
 
 
ca_rp_route
Routing
 
x(18)
 
 
ca_rrc_nbr
Repair Sequence
 
X(8)
0
 
ca_rrc_seq
Repair Step
 
>>9
 
 
ca_schedule_ca
Schedule
 
yes/no
 
 
ca_seq
Sequence
Seq
>>>>>>9
 
 
ca_serial
Serial
 
x(18)
 
 
ca_severity
Severity
 
x(8)
 
 
ca_ship_to
Ship To
 
x(8)
 
 
ca_site
Site
 
x(8)
 
 
ca_snt_date
 
 
99/99/99
 
 
ca_snt_time
 
 
->,>>>,>>9
 
 
ca_so_nbr
So No
 
x(8)
 
 
ca_sq_nbr
Sale Quote
 
x(8)
 
 
ca_sr
Update SR
 
x(8)
 
 
ca_start_date
Start Date
 
99/99/99
 
 
ca_status
Status
 
x(8)
 
 
ca_suspended
Suspended
 
yes/no
 
 
ca_sv_code
Service Type
Svc Type
x(8)
 
 
ca_svc_type
 
 
x(1)
 
 
ca_tax_date
Tax Date
 
99/99/99
 
 
ca_tax_env
Tax Environment
Tax Env
X(16)
 
 
ca_tax_pct
 
 
->>9.99%
10
 
ca_tax_usage
Tax Usage
TaxUsage
X(8)
 
 
ca_taxable
Taxable
Tax
yes/no
 
 
ca_taxc
Tax Class
TxC
x(3)
 
 
ca_time_log
Time Spent
 
>>9.99
10
 
ca_time_stmp
Time
 
99:99
 
 
ca_to_que
To Queue
Queue
x(8)
 
 
ca_trv_dist
Travel Dist
Trvl Dst
->,>>>,>>9
 
 
ca_trv_time
Travel Time
 
999:99
0
 
ca_trv_um
Travel UM
UM
x(2)
 
 
ca_type
Type
 
x(8)
 
 
ca_upd_isb
Update ISB
 
yes/no
 
 
ca_user1
Ufld1
 
x(8)
 
 
ca_user2
Ufld2
 
x(8)
 
 
ca_waiting_parts
Awaiting Items
 
yes/no
 
 
oid_ca_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
ca_area
no
ca_domain
yes
no
 
 
 
ca_category
yes
no
 
 
 
ca_area
yes
no
 
 
 
ca_eu_nbr
yes
no
 
ca_assign
no
ca_domain
yes
no
 
 
 
ca_assign
yes
no
 
 
 
ca_category
yes
no
 
ca_contract
no
ca_domain
yes
no
 
 
 
ca_contract
yes
no
 
 
 
ca_opn_date
yes
no
 
ca_customer
no
ca_domain
yes
no
 
 
 
ca_category
yes
no
 
 
 
ca_customer
yes
no
 
ca_eu_nbr
no
ca_domain
yes
no
 
 
 
ca_eu_nbr
yes
no
 
 
 
ca_category
yes
no
 
 
 
ca_nbr
yes
no
ca_nbr
yes
ca_domain
yes
no
 
 
 
ca_category
yes
no
 
 
 
ca_nbr
yes
no
 
ca_nbr_only
no
ca_domain
yes
no
 
 
 
ca_nbr
yes
no
 
ca_nxt_date
no
ca_domain
yes
no
 
 
 
ca_category
yes
no
 
 
 
ca_nxt_date
yes
no
 
 
 
ca_nxt_tim
yes
no
 
ca_part
no
ca_domain
yes
no
 
 
 
ca_part
yes
no
 
ca_que
no
ca_domain
yes
no
 
 
 
ca_category
yes
no
 
 
 
ca_que
yes
no
 
 
 
ca_pri
yes
no
 
ca_serial
no
ca_domain
yes
no
 
 
 
ca_serial
yes
no
 
 
 
ca_ref
yes
no
 
ca_sr
no
ca_domain
yes
no
 
 
 
ca_sr
yes
no
 
oid_ca_mstr
yes
oid_ca_mstr
yes
no
CBalance
Supplier Balance
 
 
Field Name
Label
Col-Label
Format
Dec
 
CBalance_ID
Record ID
 
-99999999999
 
 
CBalanceCC
SC Balance
 
->>>,>>>,>>>,>>9.99
4
 
CBalanceLC
BC Balance
 
->>>,>>>,>>>,>>9.99
4
 
CBalanceTC
TC Balance
 
->>>,>>>,>>>,>>9.99
4
 
Company_ID
Link to Company
 
-99999999999
 
 
Creditor_ID
Link to Creditor
 
-99999999999
 
 
Currency_ID
Link to Currency
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
Company
no
Company_ID
yes
no
 
Creditor
no
Creditor_ID
yes
no
 
CreditorCurrComp
yes
Company_ID
yes
no
 
 
 
Creditor_ID
yes
no
 
 
 
Currency_ID
yes
no
 
Currency
no
Currency_ID
yes
no
 ∗
Prim
yes
CBalance_ID
yes
no
ccb_mstr
Cycle Count Batch
 
 
Field Name
Label
Col-Label
Format
Dec
 
ccb__qadc01
 
 
x(24)
 
 
ccb__qadc02
 
 
x(24)
 
 
ccb_amt_diff
Difference Amount
 
->>>,>>>,>>>,>>9.99
10
 
ccb_cc_status
State
 
>9
 
 
ccb_domain
Domain
 
x(8)
 
 
ccb_end_timestamp
End Date/Time
 
99/99/99 HH:MM:SS
 
 
ccb_loc
Location
 
x(8)
 
 
ccb_mod_date
Modified Date
Mod Date
99/99/99
 
 
ccb_mod_userid
User ID
 
x(8)
 
 
ccb_part
Item
 
x(18)
 
 
ccb_pct_qty_diff
Qty On Hand Variance
 
->>>,>>9.9<%
10
 
ccb_pct_qty_usage
Annual Usage Variance
 
->>>,>>9.9<%
10
 
ccb_qty_begin
Begin Quantity
 
->,>>>,>>9.9<<<<<<<<
10
 
ccb_qty_counted
Count Quantity
 
->,>>>,>>9.9<<<<<<<<
10
 
ccb_site
Site
 
x(8)
 
 
ccb_start_timestamp
State Date/Time
 
99/99/99 HH:MM:SS
 
 
ccb_type
Type
 
>9
 
 
ccb_user1
User Field Character 1
 
x(24)
 
 
ccb_user2
User Field Character 2
 
x(24)
 
 
oid_ccb_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
ccb_site_loc_pt
yes
ccb_domain
yes
no
 
 
 
ccb_site
yes
no
 
 
 
ccb_loc
yes
no
 
 
 
ccb_part
yes
no
 
 
 
ccb_start_timestamp
yes
no
 
oid_ccb_mstr
yes
oid_ccb_mstr
yes
no
ccc_ctrl
Credit Card Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
ccc__qadc01
 
 
x(8)
 
 
ccc__qadc02
 
 
x(8)
 
 
ccc__qadc03
 
 
x(8)
 
 
ccc__qadc04
 
 
x(8)
 
 
ccc__qadc05
 
 
x(8)
 
 
ccc__qadd01
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
ccc__qadi01
 
 
>>>>>>9
 
 
ccc__qadi02
 
 
->>>>>>>9
 
 
ccc__qadl01
 
 
yes/no
 
 
ccc__qadt01
 
 
99/99/99
 
 
ccc_cc_appserver_name
CC App Service Name
 
x(24)
 
 
ccc_cc_auth_exp_days
Expiration Days
Exp Days
>>9
 
 
ccc_cc_auto_capture
Automatic CC Capture
Auto Capt
yes/no
 
 
ccc_cc_hold_status
Hold Action Status
St
x(2)
 
 
ccc_domain
Domain
 
x(8)
 
 
ccc_mod_date
Modified Date
Mod Date
99/99/99
 
 
ccc_mod_userid
User ID
 
x(8)
 
 
ccc_user1
User Field 1
 
x(24)
 
 
ccc_user2
User Field 2
 
x(24)
 
 
oid_ccc_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
ccc_index1
yes
ccc_domain
yes
no
 
oid_ccc_ctrl
yes
oid_ccc_ctrl
yes
no
ccd_mstr
Service/Support Call Fault Code Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
ccd__chr01
User #1
 
x(8)
 
 
ccd__chr02
User #2
 
x(8)
 
 
ccd__chr03
User #3
 
x(8)
 
 
ccd__chr04
User #4
 
x(8)
 
 
ccd__chr05
User #5
 
x(8)
 
 
ccd__chr06
User #6
 
x(8)
 
 
ccd__chr07
User #7
 
x(8)
 
 
ccd__chr08
User #8
 
x(8)
 
 
ccd__log01
User Logical Field 1
 
yes/no
 
 
ccd__qadc01
QAD Character Field 1
 
X(8)
 
 
ccd__qadc02
QAD Character Field 2
 
X(8)
 
 
ccd__qadc03
QAD Character Field 3
 
X(8)
 
 
ccd__qadc04
QAD Character Field 4
 
X(8)
 
 
ccd_ca_nbr
Call Number
 
x(8)
 
 
ccd_cause
Cause
 
x(8)
 
 
ccd_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
ccd_date
Problem Date
 
x(8)
 
 
ccd_domain
Domain
 
x(8)
 
 
ccd_eng_code
Engineer
 
x(8)
0
 
ccd_hours
Hours
 
>>,>>9.99
10
 
ccd_itm_line
Item Line
It Ln
>>9
 
 
ccd_line
Line
 
>>9
 
 
ccd_mod_date
Modified Date
Mod Date
99/99/99
 
 
ccd_mod_userid
User ID
 
X(8)
 
 
ccd_opn_date
Open Date
 
99/99/99
 
 
ccd_part
Component
 
x(18)
 
 
ccd_problem
Problem
 
x(8)
0
 
ccd_resolution
Resolution
Resolved
x(8)
0
 
ccd_serial
Component Serial
 
x(18)
 
 
ccd_sys_part
System Item
 
x(18)
 
 
ccd_sys_ser
System Serial
 
x(18)
 
 
ccd_type
Type
 
x(8)
 
 
ccd_user1
Ufld1
 
x(8)
 
 
ccd_user2
Ufld2
 
x(8)
 
 
oid_ccd_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
ccd_ca_nbr
yes
ccd_domain
yes
no
 
 
 
ccd_ca_nbr
yes
no
 
 
 
ccd_opn_date
yes
no
 
 
 
ccd_itm_line
yes
no
 
 
 
ccd_part
yes
no
 
 
 
ccd_line
yes
no
 
ccd_part
no
ccd_domain
yes
no
 
 
 
ccd_part
yes
no
 
 
 
ccd_date
yes
no
 
 
 
ccd_problem
yes
no
 
ccd_sys_part
no
ccd_domain
yes
no
 
 
 
ccd_sys_part
yes
no
 
 
 
ccd_date
yes
no
 
 
 
ccd_problem
yes
no
 
oid_ccd_mstr
yes
oid_ccd_mstr
yes
no
cclscd_det
Ship-To/Container Price List Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
cclscd__qadc01
 
 
x(24)
 
 
cclscd__qadc02
 
 
x(24)
 
 
cclscd_curr
Currency
Cur
x(3)
 
 
cclscd_domain
Domain
 
x(8)
 
 
cclscd_expire
Expire
 
99/99/99
 
 
cclscd_mod_date
Modified Date
Mod Date
99/99/99
 
 
cclscd_mod_userid
User ID
 
x(8)
 
 
cclscd_part
Container
 
x(18)
 
 
cclscd_price
Price
 
->>>>,>>>,>>9.99<<<
10
 
cclscd_ref
Reference
 
x(30)
 
 
cclscd_shipto
Ship-To/Dock
 
x(8)
 
 
cclscd_start
Start
 
99/99/99
 
 
cclscd_userc01
User Field Character 1
 
x(24)
 
 
cclscd_userc02
User Field Character 2
 
x(24)
 
 
oid_cclscd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
cclscd_shipto
yes
cclscd_domain
yes
no
 
 
 
cclscd_shipto
yes
no
 
 
 
cclscd_part
yes
no
 
 
 
cclscd_curr
yes
no
 
 
 
cclscd_start
yes
no
 
oid_cclscd_det
yes
oid_cclscd_det
yes
no
cclsc_mstr
Ship-To/Container Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
cclsc__qadc02
 
 
x(24)
 
 
cclsc__qadc03
 
 
x(24)
 
 
cclsc_charge_type
Charge Type
Charge!Type
x(8)
 
 
cclsc_curr
Currency
Cur
x(3)
 
 
cclsc_domain
Domain
 
x(8)
 
 
cclsc_mod_date
Modified Date
Mod Date
99/99/99
 
 
cclsc_mod_userid
User ID
 
x(8)
 
 
cclsc_part
Container
 
x(18)
 
 
cclsc_recalc_cont_taxes
Recalculate Container Taxes
Recalc Cont Tax
x(1)
 
 
cclsc_shipto
Ship-To/Dock
 
x(8)
 
 
cclsc_tax_usage
Tax Usage
Tax Use
x(8)
 
 
cclsc_userc01
User Field Character 1
 
x(24)
 
 
cclsc_userc02
User Field Character 2
 
x(24)
 
 
oid_cclsc_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
cclsc_shipto
yes
cclsc_domain
yes
no
 
 
 
cclsc_shipto
yes
no
 
 
 
cclsc_part
yes
no
 
 
 
cclsc_curr
yes
no
 
oid_cclsc_mstr
yes
oid_cclsc_mstr
yes
no
ccls_mstr
Container/Line Charge Ship-From/Ship-To Control Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
ccls__qadc01
 
 
x(24)
 
 
ccls__qadc02
 
 
x(24)
 
 
ccls_cc_asn
Include Container Charges on ASN
 
yes/no
 
 
ccls_cc_invoice
Include Container Charges on Invoice
 
yes/no
 
 
ccls_charge_type
Line Charge Calculation Type
 
x(8)
 
 
ccls_domain
Domain
 
x(8)
 
 
ccls_edit_lc_shipper
Edit Line Charges on Shipper
 
yes/no
 
 
ccls_lc_asn
Include Line Charges on ASN
 
yes/no
 
 
ccls_lc_invoice
Include Line Charges on Invoice
 
yes/no
 
 
ccls_mod_date
Modified Date
Mod Date
99/99/99
 
 
ccls_mod_userid
User ID
 
x(8)
 
 
ccls_separate_cont_ld
Separate Legal Doc for Container
 
yes/no
 
 
ccls_shipfrom
Ship-From
 
x(8)
 
 
ccls_shipto
Ship-To/Dock
 
x(8)
 
 
ccls_userc01
User Field Character 1
 
x(24)
 
 
ccls_userc02
User Field Character 2
 
x(24)
 
 
oid_ccls_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
ccls_shipfrom
yes
ccls_domain
yes
no
 
 
 
ccls_shipfrom
yes
no
 
 
 
ccls_shipto
yes
no
 
oid_ccls_mstr
yes
oid_ccls_mstr
yes
no
ccl_ctrl
Container/Line Charge Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
ccl__qadc02
 
 
x(24)
 
 
ccl__qadc03
 
 
x(24)
 
 
ccl__qadi01
 
 
->>>>>>>9
 
 
ccl_cc_asn
Include Container Charges on ASN
 
yes/no
 
 
ccl_cc_invoice
Include Container Charges on Invoice
 
yes/no
 
 
ccl_charge_type
Line Charge Calculation Type
 
x(8)
 
 
ccl_cont_active
Enable Container Charges
 
yes/no
 
 
ccl_domain
Domain
 
x(8)
 
 
ccl_edit_lc_shipper
Edit Line Charges on Shipper
 
yes/no
 
 
ccl_lc_asn
Include Line Charges on ASN
 
yes/no
 
 
ccl_lc_invoice
Include Line Charges on Invoice
 
yes/no
 
 
ccl_line_active
Enable Line Charges
 
yes/no
 
 
ccl_mod_date
Modified Date
Mod Date
99/99/99
 
 
ccl_mod_userid
User ID
 
x(8)
 
 
ccl_recalc_cont_taxes
Recalculate Container Taxes
Recalc Cont Tax
x(1)
 
 
ccl_separate_cont_ld
Separate Legal Doc for Container
 
yes/no
 
 
ccl_userc01
User Field Character 1
 
x(24)
 
 
ccl_userc02
User Field Character 2
 
x(24)
 
 
oid_ccl_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
ccl_index1
yes
ccl_domain
yes
no
 
oid_ccl_ctrl
yes
oid_ccl_ctrl
yes
no
CCollection
Supplier PaymentSelection
 
 
Field Name
Label
Col-Label
Format
Dec
 
CCollection_ID
Record ID
 
-99999999999
 
 
CCollectionBalanceCC
SC Balance
 
->>>,>>>,>>>,>>9.99
4
 
CCollectionBalanceCreditCC
SC Credit Balance
 
->>>,>>>,>>>,>>9.99
4
 
CCollectionBalanceCreditLC
BC Credit Balance
 
->>>,>>>,>>>,>>9.99
4
 
CCollectionBalanceCreditTC
TC Credit Balance
 
->>>,>>>,>>>,>>9.99
4
 
CCollectionBalanceDebitCC
SC Debit Balance
 
->>>,>>>,>>>,>>9.99
4
 
CCollectionBalanceDebitLC
BC Debit Balance
 
->>>,>>>,>>>,>>9.99
4
 
CCollectionBalanceDebitTC
TC Debit Balance
 
->>>,>>>,>>>,>>9.99
4
 
CCollectionBalanceLC
BC Balance
 
->>>,>>>,>>>,>>9.99
4
 
CCollectionBalanceTC
TC Balance
 
->>>,>>>,>>>,>>9.99
4
 
CCollectionCreationDate
Creation Date
 
99/99/9999
 
 
CCollectionCreationTime
Creation Time
 
99999
 
 
CCollectionIsAutomatic
Automatic
 
yes/no
 
 
CCollectionIsExecuted
Executed
 
yes/no
 
 
CCollectionIsOpen
Is Open
 
yes/no
 
 
CCollectionName
Name
 
x(40)
 
 
CCollectionNumber
Number
 
99999999999
 
 
CCollectionOrigCreditCC
SC Original Credit
 
->>>,>>>,>>>,>>9.99
4
 
CCollectionOrigCreditLC
BC Original Credit
 
->>>,>>>,>>>,>>9.99
4
 
CCollectionOrigCreditTC
TC Original Credit
 
->>>,>>>,>>>,>>9.99
4
 
CCollectionOrigDebitCC
SC Original Debit
 
->>>,>>>,>>>,>>9.99
4
 
CCollectionOrigDebitLC
BC Original Debit
 
->>>,>>>,>>>,>>9.99
4
 
CCollectionOrigDebitTC
TC Original Debit
 
->>>,>>>,>>>,>>9.99
4
 
CCollectionPaySelCodeList
Payment Selection List
 
x(40)
 
 
CCollectionReference
Reference
 
x(40)
 
 
CCollectionRequestedDate
Requested Date
 
99/99/9999
 
 
CCollectionYear
Year
 
->,>>>,>>9
 
 
Company_ID
Link to Company
 
-99999999999
 
 
CreationUsr_ID
Link to Usr
 
-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)
 
 
GL_ID
GL Account
 
-99999999999
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
PaySel_ID
Link to PaySel
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
CCollRef
no
CCollectionReference
yes
no
 
CompanyIdx
no
Company_ID
yes
no
 
CreationUsr
no
CreationUsr_ID
yes
no
 
GL
no
GL_ID
yes
no
 
IsOpen
no
CCollectionIsOpen
yes
no
 
PaySelIdx
no
PaySel_ID
yes
no
 ∗
Prim
yes
CCollection_ID
yes
no
 
UniqueIdx
yes
Company_ID
yes
no
 
 
 
CCollectionYear
yes
no
 
 
 
CCollectionNumber
yes
no
cctr_hist
Credit Card Transaction History
 
 
Field Name
Label
Col-Label
Format
Dec
 
cctr__qadc01
 
 
x(8)
 
 
cctr__qadd01
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
cctr__qadi01
 
 
>>>>>>9
 
 
cctr__qadl01
 
 
yes/no
 
 
cctr__qadt01
 
 
99/99/99
 
 
cctr_action_code
Action Code
Action
x(3)
 
 
cctr_amt
Authorized Amount
Auth Amt
->>>>,>>>,>>9.99<
10
 
cctr_auth_code
Authorization Code
Auth Code
x(8)
 
 
cctr_auth_expire_date
Expire Date
Expire
99/99/99
 
 
cctr_auth_nbr
Authorization Number
 
x(20)
 
 
cctr_aux_msg
Auxiliary Message
 
x(60)
 
 
cctr_avs_code
AVS Code
 
x(4)
 
 
cctr_cc_nbr
Credit Card Number
 
x(24)
 
 
cctr_cust_txn
Customer Trans ID
 
x(20)
 
 
cctr_domain
Domain
 
x(8)
 
 
cctr_err_msg
Error Message
 
x(40)
 
 
cctr_internal_tx
Internal Transaction
 
yes/no
 
 
cctr_inv_nbr
Invoice Number
Invoice
x(22)
 
 
cctr_merch_txn
Merchant Trans ID
 
x(20)
 
 
cctr_mod_date
Modified Date
Mod Date
99/99/99
 
 
cctr_mod_userid
User ID
 
x(8)
 
 
cctr_nbr
Sales Order
Order
x(8)
 
 
cctr_ref_code
Reference Code
Reference
x(12)
 
 
cctr_status
Status Code
 
x(20)
 
 
cctr_trnbr
Transaction Number
Trans
>>>>>>>>9
 
 
cctr_tx_date
Transaction Date
Tran Date
99/99/99
 
 
cctr_tx_time
Transaction Time
Time
x(8)
 
 
cctr_tx_type
Transaction Type
 
x(8)
 
 
cctr_user1
User Field 1
 
x(24)
 
 
cctr_user2
User Field 2
 
x(24)
 
 
oid_cctr_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
cctr_auth_nbr
no
cctr_domain
yes
no
 
 
 
cctr_auth_nbr
yes
no
 
 
 
cctr_tx_date
yes
no
 
cctr_date_time
no
cctr_domain
yes
no
 
 
 
cctr_tx_date
yes
no
 
 
 
cctr_tx_time
yes
no
 
cctr_inv_nbr
no
cctr_domain
yes
no
 
 
 
cctr_inv_nbr
yes
no
 
cctr_nbr
no
cctr_domain
yes
no
 
 
 
cctr_nbr
yes
no
 
 
 
cctr_tx_date
yes
no
cctr_trnbr
yes
cctr_domain
yes
no
 
 
 
cctr_trnbr
yes
no
 
oid_cctr_hist
yes
oid_cctr_hist
yes
no
cct_mstr
Container Charge Type Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
cct__qadc01
 
 
x(24)
 
 
cct__qadc02
 
 
x(24)
 
 
cct_charge_type
Charge Type
 
x(8)
 
 
cct_container_type
Applies To
 
Container/Line
 
 
cct_desc1
Description
 
x(32)
 
 
cct_desc2
Description
 
x(32)
 
 
cct_desc3
Description
 
x(32)
 
 
cct_desc4
Description
 
x(32)
 
 
cct_domain
Domain
 
x(8)
 
 
cct_mod_date
Modified Date
Mod Date
99/99/99
 
 
cct_mod_userid
User ID
 
x(8)
 
 
cct_prgm
Run Program
 
x(12)
 
 
cct_userc01
User Field Character 1
 
x(24)
 
 
cct_userc02
User Field Character 2
 
x(24)
 
 
oid_cct_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
cct_charge_type
yes
cct_domain
yes
no
 
 
 
cct_charge_type
yes
no
 
oid_cct_mstr
yes
oid_cct_mstr
yes
no
cc_mstr
Cost Center Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
cc__qadc01
 
 
x(8)
 
 
cc_active
Active
Act
yes/no
 
 
cc_ctr
Cost Ctr
CC
x(4)
 
 
cc_desc
Description
 
x(24)
 
 
cc_domain
Domain
 
x(8)
 
 
cc_user1
Ufld1
 
x(8)
 
 
cc_user2
Ufld2
 
x(8)
 
 
oid_cc_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
cc_ctr
yes
cc_domain
yes
no
 
 
 
cc_ctr
yes
no
 
cc_desc
no
cc_domain
yes
no
 
 
 
cc_desc
yes
no
 
oid_cc_mstr
yes
oid_cc_mstr
yes
no
cdf_mstr
Service/Support Call Default Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
cdf__chr01
User Field #1
 
x(8)
0
 
cdf__chr02
User Field #2
 
x(8)
 
 
cdf__chr03
User Field #3
 
x(8)
 
 
cdf__chr04
User Field #4
 
x(8)
 
 
cdf__dec01
User Decimal #1
 
->>>,>>>,>>9.99<<<<
10
 
cdf__dec02
User Decimal #2
 
->>>,>>>,>>9.99<<<<
10
 
cdf__dec03
User Decimal #3
 
->>>,>>>,>>9.99<<<<
10
 
cdf__dte01
User Date #1
 
99/99/99
 
 
cdf__dte02
User Date #2
 
99/99/99
 
 
cdf__dte03
User Date #3
 
99/99/99
 
 
cdf__log01
User Logical #1
 
yes/no
 
 
cdf__log02
User Logical #2
 
yes/no
 
 
cdf__log03
User Logical #3
 
yes/no
 
 
cdf__qadc01
Qad Field #1
 
x(8)
 
 
cdf__qadc02
Qad Field #2
 
x(8)
 
 
cdf__qadc03
Qad Field #3
 
x(8)
 
 
cdf__qadc04
Qad Field #4
 
x(8)
 
 
cdf__qadd01
Qad Date #1
 
99/99/99
 
 
cdf__qadd02
Qad Date #2
 
99/99/99
 
 
cdf__qadd03
Qad Date #3
 
99/99/99
 
 
cdf__qadde01
Qad Decimal #1
 
->>>,>>>,>>9.99<<<<
10
 
cdf__qadde02
Qad Decimal #2
 
->>>,>>>,>>9.99<<<<
10
 
cdf__qadde03
Qad Decimal #3
 
->>>,>>>,>>9.99<<<<
10
 
cdf__qadl01
Qad Logical #1
 
yes/no
 
 
cdf__qadl02
Qad Logical #2
 
yes/no
 
 
cdf__qadl03
Qad Logical #3
 
yes/no
 
 
cdf_ca_category
Category
 
x(8)
 
 
cdf_ca_desc
Call Description
 
x(50)
 
 
cdf_ca_es_nbr
Escalation
Esc
x(8)
 
 
cdf_ca_int_type
Work Code
WK Code
x(8)
 
 
cdf_ca_nxtsts
Call Next Status
 
x(8)
 
 
cdf_ca_pri
Call Priority
 
>>9
 
 
cdf_ca_prob
Call Problem
 
x(8)
 
 
cdf_ca_que
Call Queue
Queue
x(8)
 
 
cdf_ca_severity
Call Severity
 
x(8)
 
 
cdf_ca_status
Call Status
Status
x(8)
0
 
cdf_ca_type
Call Type
 
x(8)
 
 
cdf_desc
Description
 
x(24)
 
 
cdf_domain
Domain
 
x(8)
 
 
cdf_est_time
Estimated Duration
 
999:99
 
 
cdf_exec
Program
 
x(16)
 
 
cdf_group
FSM Group
 
x(8)
0
 
cdf_mod_date
Modified Date
Mod Date
99/99/99
 
 
cdf_mod_userid
User ID
 
X(8)
 
 
cdf_model
Model
 
x(18)
 
 
cdf_part
Default Item
 
x(18)
 
 
cdf_status_type
Status Type
St Type
x(8)
 
 
cdf_user1
Ufld1
 
x(8)
 
 
cdf_user2
Ufld2
 
x(8)
 
 
oid_cdf_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
cdf_gpmd
yes
cdf_domain
yes
no
 
 
 
cdf_ca_category
yes
no
 
 
 
cdf_ca_int_type
yes
no
 
 
 
cdf_model
yes
no
 
 
 
cdf_group
yes
no
 
 
 
cdf_status_type
yes
no
 
oid_cdf_mstr
yes
oid_cdf_mstr
yes
no
CDocInvoiceXrefStage
Supplier Payment Invoice Xref Stage
 
 
Field Name
Label
Col-Label
Format
Dec
 
CDocInvoiceXrefStage_ID
Record ID
 
-99999999999
 
 
CDocInvoiceXrefStageAlloTC
TC Stage Allocation
 
->>>,>>>,>>>,>>9.99
4
 
CDocInvoiceXrefStageDiscTC
TC Stage Discount
 
->>>,>>>,>>>,>>9.99
4
 
CDocInvoiceXrefStageIntTC
TC Stage Interest
 
->>>,>>>,>>>,>>9.99
4
 
CDocInvoiceXRefStagePaidAmtTC
TC Paid Amount
 
->>>,>>>,>>>,>>9.99
4
 
CDocInvoiceXRefStageWHTTC
TC WHT Amount
 
->>>,>>>,>>>,>>9.99
4
 
CDocument_ID
Link to CDocument
 
-99999999999
 
 
CDocumentInvoiceXref_ID
Link to CDocumentInvoiceXref
 
-99999999999
 
 
CInvoiceStage_ID
Link to CInvoiceStage
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
CDoc
no
CDocument_ID
yes
no
 
CIStage
no
CInvoiceStage_ID
yes
no
 
InvXref
no
CDocumentInvoiceXref_ID
yes
no
 ∗
Prim
yes
CDocInvoiceXrefStage_ID
yes
no
 
UniqueId
yes
CDocumentInvoiceXref_ID
yes
no
 
 
 
CInvoiceStage_ID
yes
no
CDocument
Supplier Payment
 
 
Field Name
Label
Col-Label
Format
Dec
 
BankNumber_ID
Link to BankNumber
 
-99999999999
 
 
CCollection_ID
Link to CCollection
 
-99999999999
 
 
CDocument_ID
Record ID
 
-99999999999
 
 
CDocumentBankChargeAmountCC
SC Bank Charge Amt
 
->>>,>>>,>>>,>>9.99
4
 
CDocumentBankChargeAmountLC
BC Bank Charge Amt
 
->>>,>>>,>>>,>>9.99
4
 
CDocumentBankChargeAmountTC
TC Bank Charge Amt
 
->>>,>>>,>>>,>>9.99
4
 
CDocumentBankChargeTaxAmountCC
SC Bank Charge Tax
 
->>>,>>>,>>>,>>9.99
4
 
CDocumentBankChargeTaxAmountLC
BC Bank Charge Tax
 
->>>,>>>,>>>,>>9.99
4
 
CDocumentBankChargeTaxAmountTC
TC Bank Charge Tax
 
->>>,>>>,>>>,>>9.99
4
 
CDocumentBankImpRef
Bank Importing Reference
 
x(255)
 
 
CDocumentCCRate
SC Rate
 
->,>>>,>>9.9999999999
10
 
CDocumentCCScale
SC Rate Scale
 
->,>>>,>>9.9999999999
10
 
CDocumentClosingDate
Closing Date
 
99/99/9999
 
 
CDocumentCreationDate
Creation Date
 
99/99/9999
 
 
CDocumentCreationTime
Creation Time
 
99999
 
 
CDocumentDueDate
Due Date
 
99/99/9999
 
 
CDocumentExchangeRate
Exchange Rate
 
->,>>>,>>9.9999999999
10
 
CDocumentIsOpen
Open
 
yes/no
 
 
CDocumentLastPrintDate
Last Printed Date
 
99/99/9999
 
 
CDocumentNumber
Payment Number
Payment Number
999999999
 
 
CDocumentOriginalCreditBC
BC Original Credit
 
->>>,>>>,>>>,>>9.99
4
 
CDocumentOriginalCreditCC
SC Original Credit
 
->>>,>>>,>>>,>>9.99
4
 
CDocumentOriginalCreditLC
BC Original Credit
 
->>>,>>>,>>>,>>9.99
4
 
CDocumentOriginalCreditTC
TC Original Credit
 
->>>,>>>,>>>,>>9.99
4
 
CDocumentOriginalDebitBC
BC Original Debit
 
->>>,>>>,>>>,>>9.99
4
 
CDocumentOriginalDebitCC
SC Original Debit
 
->>>,>>>,>>>,>>9.99
4
 
CDocumentOriginalDebitLC
BC Original Debit
 
->>>,>>>,>>>,>>9.99
4
 
CDocumentOriginalDebitTC
TC Original Debit
 
->>>,>>>,>>>,>>9.99
4
 
CDocumentPrePrintedNumber
Preprinted Number
 
>>>>>>>>>>>>9
 
 
CDocumentRateScale
Scale Factor
 
->,>>>,>>9.9999999999
10
 
CDocumentReference
Reference
 
x(40)
 
 
CDocumentReportingDateIN
Reporting Date (IN)
 
99/99/9999
 
 
CDocumentStatus
Status
 
x(20)
 
 
CDocumentSubType
Subtype
 
x(20)
 
 
CDocumentTimesPrinted
Times Printed
 
>>9
 
 
CDocumentTransTpStat
Transaction Type Status
 
->>>,>>>,>>>,>>9.99
 
 
CDocumentType
Payment Instrument
 
x(20)
 
 
CDocumentValueDays
Value Days
 
>>9
 
 
CDocumentYear
Year
Year
9999
 
 
Company_ID
Link to Company
 
-99999999999
 
 
CreationUsr_ID
Link to Usr
 
-99999999999
 
 
Creditor_ID
Supplier
 
-99999999999
 
 
Currency_ID
Currency Code
Curr
-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)
 
 
GL_ID
Bank Account
 
-99999999999
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
PaySel_ID
Code
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
BnkIdx
no
BankNumber_ID
yes
no
 
CDocRef
no
CDocumentReference
yes
no
 
ClosingDate
no
CDocumentClosingDate
yes
no
 
CollectionIdx
no
CCollection_ID
yes
no
 
CompanyIdx
no
Company_ID
yes
no
 
CreationUsr
no
CreationUsr_ID
yes
no
 
CreditorIdx
no
Creditor_ID
yes
no
 
CurrIdx
no
Currency_ID
yes
no
 
CyCrDate
no
Company_ID
yes
no
 
 
 
CDocumentCreationDate
yes
no
 
CyCredCrDate
no
Company_ID
yes
no
 
 
 
Creditor_ID
yes
no
 
 
 
CDocumentCreationDate
yes
no
 
CyCredDateIdx
no
Company_ID
yes
no
 
 
 
Creditor_ID
yes
no
 
 
 
CDocumentClosingDate
yes
no
 
CyDateIdx
no
Company_ID
yes
no
 
 
 
CDocumentClosingDate
yes
no
 
GLidx
no
GL_ID
yes
no
 
IsOpenIdx
no
CDocumentIsOpen
yes
no
 
PaySelIdx
no
PaySel_ID
yes
no
 
PrePrintIdx
no
CDocumentPrePrintedNumber
yes
no
 ∗
Prim
yes
CDocument_ID
yes
no
 
UniqueIdx
yes
Company_ID
yes
no
 
 
 
CDocumentType
yes
no
 
 
 
CDocumentYear
yes
no
 
 
 
CDocumentNumber
yes
no
CDocumentInvoiceXref
Supplier Payment Invoice Xref
 
 
Field Name
Label
Col-Label
Format
Dec
 
CDocument_ID
Link to CDocument
 
-99999999999
 
 
CDocumentInvoiceXref_ID
Record ID
 
-99999999999
 
 
CDocumentInvoiceXrefAlloCrDr
DR/CR
 
x(2)
 
 
CDocumentInvoiceXrefAlloTC
TC Allocated Amount
 
->>>,>>>,>>>,>>9.99
4
 
CDocumentInvoiceXrefDiscTC
TC Discount Amount
 
->>>,>>>,>>>,>>9.99
4
 
CDocumentInvoiceXrefIntTC
TC Interest Amount
 
->>>,>>>,>>>,>>9.99
4
 
CDocumentInvoiceXrefObjectType
Type
 
x(20)
 
 
CDocumentInvoiceXRefPaidAmtTC
TC Paid Amount
 
->>>,>>>,>>>,>>9.99
4
 
CDocumentInvoiceXRefWHTAmtCC
SC WHT Amount
 
->>>,>>>,>>>,>>9.99
4
 
CDocumentInvoiceXRefWHTAmtLC
BC WHT Amount
 
->>>,>>>,>>>,>>9.99
4
 
CDocumentInvoiceXRefWHTAmtTC
TC WHT Amount
 
->>>,>>>,>>>,>>9.99
4
 
CDocumentInvoiceXRefWHTCCRate
WHT SC Rate
 
->,>>>,>>9.9999999999
10
 
CDocumentInvoiceXRefWHTCCScale
WHT SC Scale
 
->,>>>,>>9.9999999999
10
 
CDocumentInvoiceXRefWHTLCRate
WHT BC Rate
 
->,>>>,>>9.9999999999
10
 
CDocumentInvoiceXRefWHTLCScale
WHT BC Scale
 
->,>>>,>>9.9999999999
10
 
CDocumentInvoiceXRefWHTPerc
WHT Percentage
 
->>9.99
2
 
CDocumentInvoiceXRefWHTTxFeeTC
TC WHT Taxable Fee
 
->>>,>>>,>>>,>>9.99
4
 
CInvoice_ID
Link to CInvoice
 
-99999999999
 
 
DInvoice_ID
Link to DInvoice
 
-99999999999
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
PaySelLine_ID
Link to PaySelLine
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
DInvoice
no
DInvoice_ID
yes
no
 
Document
no
CDocument_ID
yes
no
 
Invoice
no
CInvoice_ID
yes
no
 
PaySelLn
no
PaySelLine_ID
yes
no
 ∗
Prim
yes
CDocumentInvoiceXref_ID
yes
no
CDocumentPostingLine
Supplier Payment Posting Line
 
 
Field Name
Label
Col-Label
Format
Dec
 
CDocument_ID
Link to CDocument
 
-99999999999
 
 
CDocumentPostingLine_ID
Record ID
 
-99999999999
 
 
CDocumentStatus
Supplier Payment Status
 
x(20)
 
 
PostingLine_ID
Link to PostingLine
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
CDoc
no
CDocument_ID
yes
no
 
PostLine
no
PostingLine_ID
yes
no
 ∗
Prim
yes
CDocumentPostingLine_ID
yes
no
 
UniIdx
yes
CDocument_ID
yes
no
 
 
 
PostingLine_ID
yes
no
CDocumentStatus
Supplier Payment Status
 
 
Field Name
Label
Col-Label
Format
Dec
 
BankGL_ID
Bank Account Code
 
-99999999999
 
 
CDocumentStatus_ID
Record ID
 
-99999999999
 
 
CDocumentStatusDefValDays
Default Value Days
 
>>9
 
 
CDocumentStatusDocType
Payment Instrument
Pay Inst
x(20)
 
 
CDocumentStatusStatus
Status
 
x(20)
 
 
Company_ID
Link to Company
 
-99999999999
 
 
GL_ID
GL Account
 
-99999999999
 
 
Journal_ID
Daybook Code
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
BankGL
no
BankGL_ID
yes
no
 
Company
no
Company_ID
yes
no
 
GL
no
GL_ID
yes
no
 
Journal
no
Journal_ID
yes
no
 ∗
Prim
yes
CDocumentStatus_ID
yes
no
 
UniqueIdx
yes
Company_ID
yes
no
 
 
 
CDocumentStatusDocType
yes
no
 
 
 
CDocumentStatusStatus
yes
no
 
 
 
BankGL_ID
yes
no
cd_det
Master Comments
 
 
Field Name
Label
Col-Label
Format
Dec
 
cd__qadc01
 
 
x(8)
 
 
cd_cmmt[15]
Comment Data
 
x(76)
 
 
cd_domain
Domain
 
x(8)
 
 
cd_lang
Language
 
x(2)
 
 
cd_ref
Master Reference
 
x(40)
 
 
cd_seq
Page
 
>9
 
 
cd_type
Type
T
x(2)
 
 
cd_user1
Ufld1
 
x(8)
 
 
cd_user2
Ufld2
 
x(8)
 
 
oid_cd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
cd_ref_type
yes
cd_domain
yes
no
 
 
 
cd_ref
yes
no
 
 
 
cd_type
yes
no
 
 
 
cd_lang
yes
no
 
 
 
cd_seq
yes
no
 
oid_cd_det
yes
oid_cd_det
yes
no