|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|