QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
ChargesD
Warehousing Shipment Detail Charges
 
 
Field Name
Label
Col-Label
Format
Dec
 
ABSID
ABS ID
 
x(8)
 
 
BuyAmount
Charge Amount
 
->>>>,>>>,>>9.99<<<
10
 
BuyCurrency
Currency
 
x(3)
 
 
ChargeCode
Charge Code
 
x(8)
 
 
ChargeDesc
Description
 
x(40)
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
oid_ChargesD
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
QadC01
QAD Field
 
x(24)
0
 
QadC02
QAD Field
 
x(24)
0
 
QadC03
QAD Field
 
x(24)
0
 
QadC04
QAD Field
 
x(24)
0
 
QadD01
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD02
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadD03
QAD Field
 
->>>>,>>>,>>9.99<<<
10
 
QadI01
QAD Field
 
->,>>>,>>9
 
 
QadI02
QAD Field
 
->,>>>,>>9
 
 
QadI03
QAD Field
 
->,>>>,>>9
 
 
QadL01
QAD Field
 
yes/no
 
 
QadL02
QAD Field
 
yes/no
 
 
QadT01
QAD Field
 
99/99/99
 
 
QadT02
QAD Field
 
99/99/99
 
 
QadT03
QAD Field
 
99/99/99
 
 
SellAmount
Charge Amount
 
->>>>,>>>,>>9.99<<<
10
 
SellCurrency
Currency
 
x(3)
 
 
ShipVia
Ship Via
 
x(20)
 
 
Site
Site
 
x(8)
 
 
TransMode
Mode of Transport
 
x(20)
 
 
UserC01
User Field Character 1
 
x(24)
 
 
UserC02
User Field Character 2
 
x(24)
 
 
UserC03
User Field Character 3
 
x(24)
 
 
UserC04
User Field Character 4
 
x(24)
 
 
UserC05
User Field Character 5
 
x(24)
 
 
UserD01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserD02
User Field Decimal 2
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
UserL01
User Field Logical 1
 
yes/no
 
 
UserL02
User Field Logical 2
 
yes/no
 
 
UserT01
User Field Date 1
 
99/99/99
 
 
UserT02
User Field Date 2
 
99/99/99
 
 
Whse
Warehouse
Whse
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 ∗
ABSID
yes
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
ABSID
yes
no
 
 
 
ChargeCode
yes
no
 
oid_ChargesD
yes
oid_ChargesD
yes
no
 
ShipVia
no
Domain
yes
no
 
 
 
ShipVia
yes
no
 
 
 
ChargeCode
yes
no
 
SiteWhse
no
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
UserC01
yes
no
 
 
 
UserC02
yes
no
chg_mstr
Line Changeover Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
chg__chr01
 
 
x(8)
 
 
chg__chr02
 
 
x(8)
 
 
chg__chr03
 
 
x(8)
 
 
chg__chr04
 
 
x(8)
 
 
chg__chr05
 
 
x(8)
 
 
chg__dec01
 
 
>>>,>>>,>>9.99
10
 
chg_domain
Domain
 
x(8)
 
 
chg_from
From Item
From
x(18)
 
 
chg_line
Production Line
line
x(8)
 
 
chg_site
Site
 
x(8)
 
 
chg_start
Start Time
Start
->>,>>9.99
10
 
chg_time
Change Over Time
Change
->>,>>9.99
10
 
chg_to
To Item
To
x(18)
 
 
chg_user1
Ufld1
 
x(8)
 
 
chg_user2
Ufld2
 
x(8)
 
 
oid_chg_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
chg_line
yes
chg_domain
yes
no
 
 
 
chg_site
yes
no
 
 
 
chg_line
yes
no
 
 
 
chg_from
yes
no
 
 
 
chg_to
yes
no
 
oid_chg_mstr
yes
oid_chg_mstr
yes
no
CHist
Supplier Balance History
 
 
Field Name
Label
Col-Label
Format
Dec
 
CBalance_ID
Link to CBalance
 
-99999999999
 
 
CHist_ID
Record ID
 
-99999999999
 
 
CHistBalanceCC
SC Balance
 
->>>,>>>,>>>,>>9.99
4
 
CHistBalanceLC
BC Balance
 
->>>,>>>,>>>,>>9.99
4
 
CHistBalanceTC
TC Balance
 
->>>,>>>,>>>,>>9.99
4
 
CHistGrossCredNoteCC
SC Gross Credit Note
 
->>>,>>>,>>>,>>9.99
4
 
CHistGrossCredNoteLC
BC Gross Credit Note
 
->>>,>>>,>>>,>>9.99
4
 
CHistGrossCredNoteTC
TC Gross Credit Note
 
->>>,>>>,>>>,>>9.99
4
 
CHistGrossInvoiceCC
SC Gross Invoice
 
->>>,>>>,>>>,>>9.99
4
 
CHistGrossInvoiceLC
BC Gross Invoice
 
->>>,>>>,>>>,>>9.99
4
 
CHistGrossInvoiceTC
TC Gross Invoice
 
->>>,>>>,>>>,>>9.99
4
 
CHistMovementCreditCC
SC Activity Credit
 
->>>,>>>,>>>,>>9.99
4
 
CHistMovementCreditLC
BC Activity Credit
 
->>>,>>>,>>>,>>9.99
4
 
CHistMovementCreditTC
TC Activity Credit
 
->>>,>>>,>>>,>>9.99
4
 
CHistMovementDebitCC
SC Activity Debit
 
->>>,>>>,>>>,>>9.99
4
 
CHistMovementDebitLC
BC Activity Debit
 
->>>,>>>,>>>,>>9.99
4
 
CHistMovementDebitTC
TC Activity Debit
 
->>>,>>>,>>>,>>9.99
4
 
CHistNettoCredNoteCC
SC Net Credit Note
 
->>>,>>>,>>>,>>9.99
4
 
CHistNettoCredNoteLC
BC Net to Credit Note
 
->>>,>>>,>>>,>>9.99
4
 
CHistNettoCredNoteTC
TC Net Credit Note
 
->>>,>>>,>>>,>>9.99
4
 
CHistNettoInvoiceCC
SC Net Invoice
 
->>>,>>>,>>>,>>9.99
4
 
CHistNettoInvoiceLC
BC Net to Invoice
 
->>>,>>>,>>>,>>9.99
4
 
CHistNettoInvoiceTC
TC Net Invoice
 
->>>,>>>,>>>,>>9.99
4
 
CHistYearPeriodFrom
From Year GL Period
 
->,>>>,>>9
 
 
CHistYearPeriodTill
To Year GL Period
 
->,>>>,>>9
 
 
Company_ID
Link to Company
 
-99999999999
 
 
CostCentre_ID
Link to CostCentre
 
-99999999999
 
 
Creditor_ID
Link to Creditor
 
-99999999999
 
 
Currency_ID
Link to Currency
 
-99999999999
 
 
Division_ID
Link to Division
 
-99999999999
 
 
GL_ID
Link to GL
 
-99999999999
 
 
Journal_ID
Link to Journal
 
-99999999999
 
 
Project_ID
Link to Project
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
CBalance
no
CBalance_ID
yes
no
 
Company
no
Company_ID
yes
no
 
CostCentre
no
CostCentre_ID
yes
no
 
Creditor
no
Creditor_ID
yes
no
 
Currency
no
Currency_ID
yes
no
 
CyCreditorYearPdFrom
no
Company_ID
yes
no
 
 
 
Creditor_ID
yes
no
 
 
 
CHistYearPeriodFrom
yes
no
 
CyCreditorYearPdTill
no
Company_ID
yes
no
 
 
 
Creditor_ID
yes
no
 
 
 
CHistYearPeriodTill
yes
no
 
CyYearPeriodFrom
no
Company_ID
yes
no
 
 
 
CHistYearPeriodFrom
yes
no
 
CyYearPeriodTill
no
Company_ID
yes
no
 
 
 
CHistYearPeriodTill
yes
no
 
Division
no
Division_ID
yes
no
 
GL
no
GL_ID
yes
no
 
Journal
no
Journal_ID
yes
no
 ∗
Prim
yes
CHist_ID
yes
no
 
Project
no
Project_ID
yes
no
 
UniqueKey
yes
Company_ID
yes
no
 
 
 
CHistYearPeriodFrom
yes
no
 
 
 
Creditor_ID
yes
no
 
 
 
Currency_ID
yes
no
 
 
 
GL_ID
yes
no
 
 
 
Division_ID
yes
no
 
 
 
Project_ID
yes
no
 
 
 
Journal_ID
yes
no
 
 
 
CostCentre_ID
yes
no
chm_mstr
Service/Support Call History Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
chm__chr01
 
 
x(8)
 
 
chm__chr02
 
 
x(8)
 
 
chm__chr03
 
 
x(8)
 
 
chm__chr04
 
 
x(8)
 
 
chm__chr05
 
 
x(8)
 
 
chm__chr06
 
 
x(8)
 
 
chm__chr07
 
 
x(8)
 
 
chm__chr08
 
 
x(8)
 
 
chm__chr09
 
 
x(8)
 
 
chm__chr10
 
 
x(8)
 
 
chm__dec01
 
 
->>>,>>>,>>9.99
10
 
chm__dec02
 
 
->>>,>>>,>>9.99
10
 
chm__dec03
 
 
->>>,>>>,>>9.99
10
 
chm__dte01
 
 
99/99/99
 
 
chm__dte02
 
 
99/99/99
 
 
chm__dte03
 
 
99/99/99
 
 
chm__dte04
 
 
99/99/99
 
 
chm__dte05
 
 
99/99/99
 
 
chm__log01
 
 
yes/no
 
 
chm__log02
 
 
yes/no
 
 
chm__log03
 
 
yes/no
 
 
chm__log04
 
 
yes/no
 
 
chm__log05
 
 
yes/no
 
 
chm__qadc03
QAD Character Field 3
 
X(8)
 
 
chm__qadc04
QAD Character Field 4
 
x(8)
 
 
chm__qadc05
QAD Character Field 5
 
x(8)
 
 
chm__qadc06
QAD Character Field 6
 
x(8)
 
 
chm__qadd01
QAD Date Field 1
 
99/99/99
 
 
chm__qadd02
QAD Date Field 2
 
99/99/99
 
 
chm__qadd03
QAD Date Field 3
 
99/99/99
 
 
chm__qadde01
QAD Decimal Field 1
 
->>,>>9.99
10
 
chm__qadde02
QAD Decimal Field 2
 
->>,>>9.99
10
 
chm__qadde03
QAD Decimal Field 3
 
->>,>>9.99
10
 
chm__qadi01
QAD Integer Field 1
 
>>>>>>>9
 
 
chm__qadi02
QAD Integer Field 2
 
->,>>>,>>9
 
 
chm__qadi03
QAD Integer Field 3
 
->,>>>,>>9
 
 
chm__qadl02
QAD Logical Field 2
 
yes/no
 
 
chm__qadl03
QAD Logical Field 3
 
yes/no
 
 
chm__qadl04
QAD Logical Field 4
 
yes/no
 
 
chm_3rd_party
Third Party Service
 
yes/no
 
 
chm_3rd_party_id
Third Party ID
 
x(12)
 
 
chm_ack_cmtindx
 
 
>>>>>>>>>>9
 
 
chm_ack_letter
Send Ack Letter
 
yes/no
 
 
chm_area
Area
 
x(8)
 
 
chm_assign
Assigned
 
x(8)
 
 
chm_bill
Bill-To
 
x(8)
 
 
chm_category
Category
 
x(8)
 
 
chm_channel
Channel
 
X(8)
0
 
chm_cline
Contract Line
 
>>>>>>>9
 
 
chm_cls_date
Closed Date
Cls Date
99/99/99
 
 
chm_cls_time
Closed Time
Cls Time
99:99
 
 
chm_cmtindx
Index
 
>>>>>>>9
 
 
chm_code
 
 
x(8)
 
 
chm_comp_date
Complete Date
 
99/99/99
 
 
chm_comp_time
Complete Time
 
99:99
 
 
chm_contract
Contract
 
x(8)
 
 
chm_cr_terms
Terms
 
x(8)
 
 
chm_created
Created
Cr
x(3)
 
 
chm_curr
Currency
Cur
x(3)
 
 
chm_customer
Customer
 
X(8)
 
 
chm_date_stmp
Date
 
99/99/99
 
 
chm_desc
Description
 
x(60)
 
 
chm_domain
Domain
 
x(8)
 
 
chm_ecmtindx
 
 
>>>>>>9
 
 
chm_enddown_date
End Down
 
99/99/99
 
 
chm_enddown_time
Time
 
99:99
 
 
chm_eng_area
Engineer Area
 
x(8)
 
 
chm_eng_group
Group
 
x(8)
 
 
chm_ent_ex
Exchange Rate
 
>>,>>9.99999<<<
10
 
chm_enter_by
Entered by
 
x(8)
 
 
chm_es_nbr
Escalation
Esc
x(8)
 
 
chm_es_seq
Sequence
Seq
>>9
 
 
chm_est_time
Estimated Length
 
999:99
 
 
chm_eu_date
End User Date
 
99/99/99
 
 
chm_eu_nbr
End User
 
x(8)
 
 
chm_eu_time
End User Time
 
99:99
 
 
chm_eu_timezone
End User Time Zone
 
X(8)
 
 
chm_ex_rate
Exch Rate
 
>>>>,>>>,>>9.9<<<<<<<<<
10
 
chm_ex_rate2
Exch Rate 2
 
>>>>,>>>,>>9.9<<<<<<<<<
10
 
chm_ex_ratetype
Rate Type
 
x(8)
 
 
chm_exru_seq
Sequence
 
>>>>>>>>9
 
 
chm_fix_rate
Fixed Rate
 
yes/no
 
 
chm_fn_nbr
Field Notification
 
x(8)
 
 
chm_from_que
From Que
Fr Que
x(8)
 
 
chm_inc_stats
Include in Stats
 
yes/no
 
 
chm_int_type
Work Code
WK Code
x(8)
 
 
chm_inv_draft
 
 
yes/no
 
 
chm_lang
Language
 
X(2)
 
 
chm_model
Model
 
x(18)
 
 
chm_name
Caller Name
Name
x(24)
 
 
chm_nbr
Call Id
 
x(8)
 
 
chm_opn_date
Call Date
Opn Date
99/99/99
 
 
chm_opn_time
Time Opened
Tm Open
x(8)
 
 
chm_part
Part No
 
x(18)
 
 
chm_phone
Phone
 
x(16)
 
 
chm_po_nbr
PO
 
x(22)
 
 
chm_pr_list
Price List
 
x(8)
 
 
chm_printed
Call Printed
 
yes/no
 
 
chm_problem
Prob/Skill
 
x(8)
 
 
chm_qo_cmtindx
 
 
>>>>>>>>>9
 
 
chm_que
Queue
 
x(8)
 
 
chm_quote
Quote Required
 
yes/no
 
 
chm_quote_curr
Currency
Cur
x(3)
 
 
chm_quote_exp
Quote Expires
 
99/99/99
 
 
chm_quote_nbr
Quote Number
Quote
X(8)
 
 
chm_quote_price
Quote Price
 
>>>>,>>>,>>9.99<<<
10
 
chm_rc_site
Repair Center Site
 
x(8)
 
 
chm_ref
Ref
 
>>>>>>>9
 
 
chm_repair_ctr
 
 
yes/no
 
 
chm_res_cmtidx
 
 
>>>>>9
 
 
chm_resolve
Resolution
 
x(8)
 
 
chm_resolve_desc
Resolution
 
x(68)
 
 
chm_rev
Rev Level
Rev
x(10)
 
 
chm_rma_nbr
RMA
 
x(8)
 
 
chm_rp_bom
Bill of Material
 
X(18)
 
 
chm_rp_route
Routing
 
X(18)
 
 
chm_rrc_nbr
Repair Sequence
 
X(8)
 
 
chm_rrc_seq
Repair Step
 
>>9
 
 
chm_schedule_ca
Schedule Call
 
yes/no
 
 
chm_serial
Serial
 
x(18)
 
 
chm_severity
Severity
 
x(8)
 
 
chm_ship_to
Ship To
 
x(8)
 
 
chm_site
Site
 
x(8)
 
 
chm_so_nbr
So No
 
x(8)
 
 
chm_sq_nbr
Sale Quote
 
x(8)
 
 
chm_sr
Update SR
 
x(8)
 
 
chm_srv_timezone
Server Time Zone
 
X(8)
 
 
chm_status
Status
 
x(8)
 
 
chm_stdown_date
Start Down
 
99/99/99
 
 
chm_stdown_time
Time
 
99:99
 
 
chm_stjob_date
Job Start
 
99/99/99
 
 
chm_stjob_time
Start Time
 
99:99
 
 
chm_sv_code
Service Type
Svc Type
x(8)
 
 
chm_svc_type
 
 
x(1)
 
 
chm_tax_date
Tax Date
 
99/99/99
 
 
chm_tax_env
Tax Environment
 
X(16)
 
 
chm_tax_pct
Tax Percent
 
->>9.99%
10
 
chm_tax_usage
Tax Usage
 
X(8)
 
 
chm_taxable
Taxable
Tax
yes/no
 
 
chm_taxc
Tax Class
TxC
x(3)
 
 
chm_time_log
Time Spent
 
>>9.99
10
 
chm_time_stmp
Time
 
99:99
 
 
chm_to_que
To Queue
Queue
x(8)
 
 
chm_trv_dist
Travel Dist
Trvl Dst
->,>>>,>>9
 
 
chm_trv_time
Travel Time
 
99:99
 
 
chm_trv_um
Travel UM
UM
x(2)
 
 
chm_type
Type
 
x(8)
 
 
chm_user1
Ufld1
 
x(8)
 
 
chm_user2
Ufld2
 
x(8)
 
 
chm_wo_lot
WO ID
 
x(8)
 
 
chm_wo_nbr
Work Order
 
x(18)
 
 
oid_chm_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
chm_assign
no
chm_domain
yes
no
 
 
 
chm_assign
yes
no
 
chm_cls_date
no
chm_domain
yes
no
 
 
 
chm_cls_date
yes
no
 
 
 
chm_nbr
yes
no
 
chm_contract
no
chm_domain
yes
no
 
 
 
chm_contract
yes
no
 
 
 
chm_opn_date
yes
no
 
chm_eu_nbr
no
chm_domain
yes
no
 
 
 
chm_eu_nbr
yes
no
 
 
 
chm_category
yes
no
 
 
 
chm_nbr
yes
no
chm_nbr
yes
chm_domain
yes
no
 
 
 
chm_category
yes
no
 
 
 
chm_nbr
yes
no
 
 
 
chm_opn_date
yes
no
 
chm_opn_date
no
chm_domain
yes
no
 
 
 
chm_opn_date
yes
no
 
 
 
chm_opn_time
yes
no
 
chm_part
no
chm_domain
yes
no
 
 
 
chm_part
yes
no
 
 
 
chm_serial
yes
no
 
 
 
chm_ref
yes
no
 
chm_que
no
chm_domain
yes
no
 
 
 
chm_category
yes
no
 
 
 
chm_que
yes
no
 
chm_sr
no
chm_domain
yes
no
 
 
 
chm_sr
yes
no
 
oid_chm_mstr
yes
oid_chm_mstr
yes
no
cild_det
Correction Invoice Link Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
cild__qadc01
 
 
x(24)
 
 
cild__qadc02
 
 
x(24)
 
 
cild_cor_inv
Correction Invoice Number
 
x(22)
 
 
cild_cor_line
Correction SO Line
Line
>>>9
 
 
cild_cor_so_nbr
Correction Invoice Sales Order
 
x(8)
 
 
cild_domain
Domain
 
x(8)
 
 
cild_line_type
Line Type
 
x(1)
 
 
cild_mod_date
Modified Date
Mod Date
99/99/99
 
 
cild_mod_userid
User ID
 
x(8)
 
 
cild_prev_inv
Corrected Invoice
 
x(8)
 
 
cild_prev_line
Corrected SO Line
Line
>>>9
 
 
cild_prev_so_nbr
Corrected Invoice Sales Order
 
x(8)
 
 
cild_user1
User Field Character 1
 
x(24)
 
 
cild_user2
User Field Character 2
 
x(24)
 
 
oid_cild_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
cild_cor_line
yes
cild_domain
yes
no
 
 
 
cild_cor_inv
yes
no
 
 
 
cild_cor_so_nbr
yes
no
 
 
 
cild_cor_line
yes
no
 
 
 
cild_line_type
yes
no
 
cild_prev_inv
no
cild_domain
yes
no
 
 
 
cild_prev_inv
yes
no
 
 
 
cild_prev_so_nbr
yes
no
 
 
 
cild_prev_line
yes
no
 
oid_cild_det
yes
oid_cild_det
yes
no
cil_mstr
Correction Invoice Link Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
cil__qadc01
 
 
x(24)
 
 
cil__qadc02
 
 
x(24)
 
 
cil_cor_inv
Correction Invoice Number
 
x(22)
 
 
cil_cor_rsn
Reason For Correction
 
x(8)
 
 
cil_cor_so_nbr
Correction Invoice Sales Order
 
x(8)
 
 
cil_domain
Domain
 
x(8)
 
 
cil_mod_date
Modified Date
Mod Date
99/99/99
 
 
cil_mod_userid
User ID
 
x(8)
 
 
cil_mstr_inv
Original Invoice
 
x(8)
 
 
cil_prev_inv
Corrected Invoice
 
x(22)
 
 
cil_prev_so_nbr
Corrected Invoice Sales Order
 
x(8)
 
 
cil_user1
User Field Character 1
 
x(24)
 
 
cil_user2
User Field Character 2
 
x(24)
 
 
oid_cil_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
cil_cor_inv
yes
cil_domain
yes
no
 
 
 
cil_cor_inv
yes
no
 
 
 
cil_cor_so_nbr
yes
no
 
cil_cor_nbr
no
cil_domain
yes
no
 
 
 
cil_cor_so_nbr
yes
no
 
cil_mstr_inv
no
cil_domain
yes
no
 
 
 
cil_mstr_inv
yes
no
 
cil_prev_inv
no
cil_domain
yes
no
 
 
 
cil_prev_inv
yes
no
 
 
 
cil_prev_so_nbr
yes
no
 
oid_cil_mstr
yes
oid_cil_mstr
yes
no
CInvoice
Supplier Invoice
 
 
Field Name
Label
Col-Label
Format
Dec
 
BLWIGroup_ID
BLWI Group Code
BLWI Group
-99999999999
 
 
CInvoice_ID
Record ID
 
-99999999999
 
 
CInvoiceAllocationStatus
Allocation Status
 
x(20)
 
 
CInvoiceBalanceCC
SC Balance
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceBalanceCreditCC
SC Balance Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceBalanceCreditLC
BC Balance Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceBalanceCreditTC
TC Balance Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceBalanceDebitCC
SC Balance Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceBalanceDebitLC
BC Balance Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceBalanceDebitTC
TC Balance Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceBalanceLC
BC Balance
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceBalanceTC
TC Balance
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceBatchNumber
Batch Number
 
x(8)
 
 
CInvoiceCCRate
SC Rate
 
->,>>>,>>9.9999999999
10
 
CInvoiceCCScale
SC Rate Scale
 
->,>>>,>>9.9999999999
10
 
CInvoiceCirecClosingDate
SIREC Closing Date
 
99/99/9999
 
 
CInvoiceCIText
Description
 
x(40)
 
 
CInvoiceClosingDate
Closing Date
 
99/99/9999
 
 
CInvoiceCommentNote
Comment
 
x(2000)
 
 
CInvoiceContact
Contact
 
x(40)
 
 
CInvoiceCreationDate
Creation Date
 
99/99/9999
 
 
CInvoiceCreationTimeString
Creation Time
 
x(10)
 
 
CInvoiceCreditorVatNumber
Supplier Tax Number
 
x(40)
 
 
CInvoiceCurrency_ID
Currency Code
Curr
-99999999999
 
 
CInvoiceCustomInvoiceRefIN
Custom Invoice Ref Nbr (IN)
 
x(30)
 
 
CInvoiceDate
Invoice Date
Inv Date
99/99/9999
 
 
CInvoiceDayBookSetCode
Supplier Daybook Set Code
Supplier Dybk Set Code
x(8)
 
 
CInvoiceDescription
Description
 
x(40)
 
 
CInvoiceDiscountDueDate
Discount Due Date
 
99/99/9999
 
 
CInvoiceDocTypeIN
Document Type (IN)
 
x(20)
 
 
CInvoiceDueDate
Due Date
 
99/99/9999
 
 
CInvoiceExchangeRate
Exchange Rate
 
->,>>>,>>9.9999999999
10
 
CInvoiceExportIDIN
Export ID (IN)
 
x(20)
 
 
CInvoiceHoldAmountTC
TC Hold Amount
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceInvCertCertificate
Invoice Certificate
 
x(16)
 
 
CInvoiceInvCertKey
Invoice Certification Key
 
x(128)
 
 
CInvoiceInvCertSignatureCurr
Signature Current Invoice
 
x(256)
 
 
CInvoiceInvCertSignaturePrev
Signature Previous Invoice
 
x(256)
 
 
CInvoiceInvCertSignatureShort
Signature
 
x(4)
 
 
CInvoiceInvCertVersion
Version
 
x(8)
 
 
CInvoiceIsDiscTaxAtInv
Discount Tax at Invoice
Disc Tax at Inv
yes/no
 
 
CInvoiceIsDiscTaxAtPaym
Discount Tax at Payment
Disc Tax at Paym
yes/no
 
 
CInvoiceIsERS
ERS
 
yes/no
 
 
CInvoiceIsExternal
External
External Invoice
yes/no
 
 
CInvoiceIsInitialStatus
Initial Status
 
yes/no
 
 
CInvoiceIsInvoiceApproved
Approved
 
yes/no
 
 
CInvoiceIsLockPayment
Lock Payment
Lock Paym
yes/no
 
 
CInvoiceIsLogisticMatching
Receiver Matching
 
yes/no
 
 
CInvoiceIsOpen
Open
 
yes/no
 
 
CInvoiceIsPrinted
Printed
 
yes/no
 
 
CInvoiceIsSelected
Selected
Sel
yes/no
 
 
CInvoiceIsSubmitForApproval
Submit for Approval
 
yes/no
 
 
CInvoiceIsTaxable
Taxable
Tax
yes/no
 
 
CInvoiceIsTaxConfirmed
Tax Confirmed
 
yes/no
 
 
CInvoiceIsTaxExcluded
Tax Excluded
Tax Excl
yes/no
 
 
CInvoiceIsVatDelay
Tax Delay
 
yes/no
 
 
CInvoiceIsWHT
Withholding Tax
 
yes/no
 
 
CInvoiceIsWithBank
With Bank
 
yes/no
 
 
CInvoiceMFText
Description
 
x(40)
 
 
CInvoiceNewTaxPointDateIN
New Tax Point Date (IN)
 
99/99/9999
 
 
CInvoiceNonDiscAmtCC
SC Non-discount Amount
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceNonDiscAmtLC
BC Non-discount Amount
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceNonDiscAmtTC
TC Non-discount Amount
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceNonRecTaxAmtTC
Non-Recoverable Tax Amount
Non-Recov Tax Amt
->>>,>>>,>>>,>>9.99
4
 
CInvoiceOriginalCreditCC
SC Invoice Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceOriginalCreditLC
BC Invoice Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceOriginalCreditTC
TC Invoice Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceOriginalDebitCC
SC Invoice Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceOriginalDebitLC
BC Invoice Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceOriginalDebitTC
TC AP Amount
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceOwnVatNumber
Own Tax Number
 
x(40)
 
 
CInvoicePoDomain
PO Domain
 
x(8)
 
 
CInvoicePoNbr
PO Number
 
x(8)
 
 
CInvoicePostingDate
Posting Date
 
99/99/9999
 
 
CInvoicePostingPeriod
GL Period
 
99
 
 
CInvoicePostingYear
Year
 
9999
 
 
CInvoicePostingYearPeriod
Year/GL Period
GL Cal Yr/GL Pd
999999
 
 
CInvoiceProtocolNumberIN
Protocol Number (IN)
 
9999999999
 
 
CinvoiceRateScale
Scale Factor
 
->,>>>,>>9.9999999999
10
 
CInvoiceReconciliationKey
Invoice Reconciliation Key
 
x(40)
 
 
CInvoiceReference
Reference
 
x(23)
 
 
CInvoiceRegistrationNr
Registration Number
 
9999999999
 
 
CInvoiceReportingDateIN
Reporting Date (IN)
 
99/99/9999
 
 
CInvoiceSiteCode
Site
 
x(8)
 
 
CInvoiceTaxPointDate
Tax Point Date
 
99/99/9999
 
 
CInvoiceTSMNumber
Payment Reference
 
x(60)
 
 
CInvoiceType
Invoice Type
 
x(20)
 
 
CInvoiceVatBaseCreditCC
SC Tax Base Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceVatBaseCreditLC
BC Tax Base Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceVatBaseCreditTC
TC Tax Base Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceVatBaseDebitCC
SC Tax Base Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceVatBaseDebitLC
BC Tax Base Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceVatBaseDebitTC
TC Tax Base Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceVatCreditCC
SC Tax Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceVatCreditLC
BC Tax Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceVatCreditTC
TC Tax Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceVatDebitCC
SC Tax Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceVatDebitLC
BC Tax Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceVatDebitTC
TC Tax Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceVatExchangeRate
Tax Exchange Rate
 
->,>>>,>>9.9999999999
10
 
CInvoiceVatRateScale
Tax Rate Scale
 
->,>>>,>>9.9999999999
10
 
CInvoiceVoucher
Voucher
 
999999999
 
 
CInvoiceWHTBaseAmtCreditCC
SC WHT Base Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceWHTBaseAmtCreditLC
BC WHT Base Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceWHTBaseAmtCreditTC
TC WHT Base Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceWHTBaseAmtDebitCC
SC WHT Base Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceWHTBaseAmtDebitLC
BC WHT Base Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceWHTBaseAmtDebitTC
TC WHT Base Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceWHTTotAmtCreditCC
SC WHT Total Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceWHTTotAmtCreditLC
BC WHT Total Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceWHTTotAmtCreditTC
TC WHT Total Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceWHTTotAmtDebitCC
SC WHT Total Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceWHTTotAmtDebitLC
BC WHT Total Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceWHTTotAmtDebitTC
TC WHT Total Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
Company_ID
Link to Company
 
-99999999999
 
 
ControlGL_ID
Account
 
-99999999999
 
 
CostCentre_ID
Cost Center
 
-99999999999
 
 
Creditor_ID
Link to Creditor
 
-99999999999
 
 
CreditorVatNumber_ID
Link to VatNumber
 
-99999999999
 
 
CustomCombo0
Custom Combo Field
 
x(20)
 
 
CustomCombo1
Custom Combo Field
 
x(20)
 
 
CustomCombo10
Custom Combo Field
 
x(20)
 
 
CustomCombo11
Custom Combo Field
 
x(20)
 
 
CustomCombo12
Custom Combo Field
 
x(20)
 
 
CustomCombo13
Custom Combo Field
 
x(20)
 
 
CustomCombo14
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
 
 
CustomDate5
Custom Date Field
 
99/99/9999
 
 
CustomDate6
Custom Date Field
 
99/99/9999
 
 
CustomDate7
Custom Date Field
 
99/99/9999
 
 
CustomDate8
Custom Date Field
 
99/99/9999
 
 
CustomDate9
Custom Date Field
 
99/99/9999
 
 
CustomDecimal0
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal1
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal10
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal11
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal12
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal13
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal14
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
 
CustomDecimal5
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal6
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal7
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal8
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal9
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)
 
 
CustomShort10
Custom Short Field
 
x(20)
 
 
CustomShort11
Custom Short Field
 
x(20)
 
 
CustomShort12
Custom Short Field
 
x(20)
 
 
CustomShort13
Custom Short Field
 
x(20)
 
 
CustomShort14
Custom Short Field
 
x(20)
 
 
CustomShort15
Custom Short Field
 
x(20)
 
 
CustomShort16
Custom Short Field
 
x(20)
 
 
CustomShort17
Custom Short Field
 
x(20)
 
 
CustomShort18
Custom Short Field
 
x(20)
 
 
CustomShort19
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)
 
 
Division_ID
Sub-Account
Sub-Acct
-99999999999
 
 
Journal_ID
Daybook Code
 
-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)
 
 
LinkedCInvoice_ID
Reference
 
-99999999999
 
 
NormalPaymentCondition_ID
Credit Terms Code
Cred Trm
-99999999999
 
 
OwnVatNumber_ID
Link to VatNumber
 
-99999999999
 
 
Period_ID
Link to Period
 
-99999999999
 
 
Project_ID
Project
 
-99999999999
 
 
PurchaseType_ID
Purchase Type
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
Reason_ID
Invoice Status Code
 
-99999999999
 
 
ReplacedCInvoice_ID
Link to CInvoice
 
-99999999999
 
 
Role_ID
Role Name
 
-99999999999
 
 
ShipToAddress_ID
City
 
-99999999999
 
 
TransactionEndCountry_ID
Country Code
Country
-99999999999
 
 
TransactionStartCountry_ID
Country Code
Country
-99999999999
 
 
VatCurrency_ID
Currency Code
Curr
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
AllocStatus
no
CInvoiceAllocationStatus
yes
no
 
CCidx
no
CostCentre_ID
yes
no
 
CInvoiceCurrency
no
CInvoiceCurrency_ID
yes
no
 
CInvoiceIsInvAppr
no
CInvoiceIsInvoiceApproved
yes
no
 
CInvoiceIsLockPaym
no
CInvoiceIsLockPayment
yes
no
 
CirecClosingDate
no
Company_ID
yes
no
 
 
 
CInvoiceCirecClosingDate
yes
no
 
Company
no
Company_ID
yes
no
 
CompanyClosingDate
no
Company_ID
yes
no
 
 
 
CInvoiceClosingDate
yes
no
 
ControlGL
no
ControlGL_ID
yes
no
 
CreationDate
no
CInvoiceCreationDate
yes
no
 
Creditor
no
Creditor_ID
yes
no
 
CyCredClosingDate
no
Company_ID
yes
no
 
 
 
Creditor_ID
yes
no
 
 
 
CInvoiceClosingDate
yes
no
 
CyCredInvDate
no
Company_ID
yes
no
 
 
 
Creditor_ID
yes
no
 
 
 
CInvoiceDate
yes
no
 
CyJrnlDateIdx
no
Company_ID
yes
no
 
 
 
Journal_ID
yes
no
 
 
 
CInvoicePostingDate
yes
no
 
CyPeriodYearPeriod
no
Company_ID
yes
no
 
 
 
CInvoicePostingYearPeriod
yes
no
 
CyYearJrnlVoucher
no
Company_ID
yes
no
 
 
 
CInvoicePostingYear
yes
no
 
 
 
Journal_ID
yes
no
 
 
 
CInvoiceVoucher
yes
no
 
Division
no
Division_ID
yes
no
 
EndCountryIdx
no
TransactionEndCountry_ID
yes
no
 
InvoiceDateIDX
no
CInvoiceDate
yes
no
 
IsInitialStatus
no
CInvoiceIsInitialStatus
yes
no
 
IsLogisticMatching
no
CInvoiceIsLogisticMatching
yes
no
 
IsOpen
no
CInvoiceIsOpen
yes
no
 
IsSelected
no
CInvoiceIsSelected
yes
no
 
IsWithBank
no
CInvoiceIsWithBank
yes
no
 
Journal
no
Journal_ID
yes
no
 
LastModIdx
no
LastModifiedDate
yes
no
 
LinkedCIIdx
no
LinkedCInvoice_ID
yes
no
 
NormPayCondIdx
no
NormalPaymentCondition_ID
yes
no
 
Period
no
Period_ID
yes
no
 
PostingDateIDX
no
CInvoicePostingDate
yes
no
 
PostingYear
no
CInvoicePostingYear
yes
no
 ∗
Prim
yes
CInvoice_ID
yes
no
 
Project
no
Project_ID
yes
no
 
PurchaseType
no
PurchaseType_ID
yes
no
 
ReasonIdx
no
Reason_ID
yes
no
 
ReferenceIdx
no
CInvoiceReference
yes
no
 
RegistrationNr
no
CInvoiceRegistrationNr
yes
no
 
ReplacedCI
no
ReplacedCInvoice_ID
yes
no
 
RoleIdx
no
Role_ID
yes
no
 
ShipTo
no
ShipToAddress_ID
yes
no
 
StartCountryIdx
no
TransactionStartCountry_ID
yes
no
 
TSMIdx
no
CInvoiceTSMNumber
yes
no
 
UniqueIdx
yes
Company_ID
yes
no
 
 
 
CInvoiceRegistrationNr
yes
no
 
VatCurrency
no
VatCurrency_ID
yes
no
 
VatNumber
no
OwnVatNumber_ID
yes
no
 
VatNumIdx
no
CreditorVatNumber_ID
yes
no
 
ViewIndex
no
Company_ID
yes
no
 
 
 
CInvoicePostingYear
yes
no
 
 
 
CInvoicePostingPeriod
yes
no
 
 
 
Journal_ID
yes
no
 
 
 
CInvoiceVoucher
yes
no
 
Voucher
no
CInvoiceVoucher
yes
no
CInvoiceApHist
Supplier Invoice Approval History
 
 
Field Name
Label
Col-Label
Format
Dec
 
CInvoice_ID
Link to CInvoice
 
-99999999999
 
 
CInvoiceApHist_ID
Record ID
 
-99999999999
 
 
CInvoiceApHistComments
Approval Comments
 
x(255)
 
 
CInvoiceApHistDate
Date
 
99/99/9999
 
 
CInvoiceApHistDescription
Description
 
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
 
 
Reason_ID
Link to Reason
 
-99999999999
 
 
Usr_ID
Link to Usr
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
CIIdx
no
CInvoice_ID
yes
no
 ∗
Prim
yes
CInvoiceApHist_ID
yes
no
 
UsrIdx
no
Usr_ID
yes
no
CInvoiceBank
Supplier Invoice Bank Records
 
 
Field Name
Label
Col-Label
Format
Dec
 
BankNumber_ID
Bank Number
Bank Account No
-99999999999
 
 
CInvoice_ID
Link to CInvoice
 
-99999999999
 
 
CInvoiceBank_ID
Record ID
 
-99999999999
 
 
CInvoiceBankToPayTC
TC Payment Amount
 
->>>,>>>,>>>,>>9.99
4
 
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
 
BankNumber
no
BankNumber_ID
yes
no
 
CInvoice
no
CInvoice_ID
yes
no
 ∗
Prim
yes
CInvoiceBank_ID
yes
no
 
UniqueIdx
yes
CInvoice_ID
yes
no
 
 
 
BankNumber_ID
yes
no
CInvoiceBankPayCode
Supplier invoice Bank Payment Code
 
 
Field Name
Label
Col-Label
Format
Dec
 
CInvoiceBank_ID
Link to CInvoiceBank
 
-99999999999
 
 
CInvoiceBankPayCode_ID
Record ID
 
-99999999999
 
 
CInvoiceBankPayCodeValue
Attribute Value
 
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)
 
 
PayFormatCode_ID
Link to PayFormatCode
 
-99999999999
 
 
PayFormatGroup_ID
Link to PayFormatGroup
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
CIBank
no
CInvoiceBank_ID
yes
no
 
CodeIdx
no
PayFormatCode_ID
yes
no
 
GrpIdx
no
PayFormatGroup_ID
yes
no
 ∗
Prim
yes
CInvoiceBankPayCode_ID
yes
no
CInvoiceMovement
Supplier Invoice Movements
 
 
Field Name
Label
Col-Label
Format
Dec
 
CInvoice_ID
Link to CInvoice
 
-99999999999
 
 
CInvoiceMovement_ID
Record ID
 
-99999999999
 
 
CInvoiceMovementDiscountTC
TC Discount Amount
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceMovementIsForDraft
For Draft
 
yes/no
 
 
CInvoiceMovementPostDate
Posting Date
 
99/99/9999
 
 
CInvoiceMovementType
Type
 
x(20)
 
 
CInvoiceMovementYearPeriod
Year/GL Period
 
999999
 
 
Company_ID
Link to Company
 
-99999999999
 
 
Creditor_ID
Link to Creditor
 
-99999999999
 
 
CustomCombo0
Custom Combo Field
 
x(20)
 
 
CustomCombo1
Custom Combo Field
 
x(20)
 
 
CustomCombo2
Custom Combo Field
 
x(20)
 
 
CustomCombo3
Custom Combo Field
 
x(20)
 
 
CustomCombo4
Custom Combo Field
 
x(20)
 
 
CustomCombo5
Custom Combo Field
 
x(20)
 
 
CustomCombo6
Custom Combo Field
 
x(20)
 
 
CustomCombo7
Custom Combo Field
 
x(20)
 
 
CustomCombo8
Custom Combo Field
 
x(20)
 
 
CustomCombo9
Custom Combo Field
 
x(20)
 
 
CustomDate0
Custom Date Field
 
99/99/9999
 
 
CustomDate1
Custom Date Field
 
99/99/9999
 
 
CustomDate2
Custom Date Field
 
99/99/9999
 
 
CustomDate3
Custom Date Field
 
99/99/9999
 
 
CustomDate4
Custom Date Field
 
99/99/9999
 
 
CustomDecimal0
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal1
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal2
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal3
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal4
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomInteger0
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger1
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger2
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger3
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger4
Custom Integer Field
 
->,>>>,>>9
 
 
CustomLong0
Custom Long Field
 
x(255)
 
 
CustomLong1
Custom Long Field
 
x(255)
 
 
CustomNote
Custom Note Field
 
x(2000)
 
 
CustomShort0
Custom Short Field
 
x(20)
 
 
CustomShort1
Custom Short Field
 
x(20)
 
 
CustomShort2
Custom Short Field
 
x(20)
 
 
CustomShort3
Custom Short Field
 
x(20)
 
 
CustomShort4
Custom Short Field
 
x(20)
 
 
CustomShort5
Custom Short Field
 
x(20)
 
 
CustomShort6
Custom Short Field
 
x(20)
 
 
CustomShort7
Custom Short Field
 
x(20)
 
 
CustomShort8
Custom Short Field
 
x(20)
 
 
CustomShort9
Custom Short Field
 
x(20)
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
Period_ID
Link to Period
 
-99999999999
 
 
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
 
CIMovYearPd
no
CInvoiceMovementYearPeriod
yes
no
 
CInvoice
no
CInvoice_ID
yes
no
 
Company
no
Company_ID
yes
no
 
Creditor
no
Creditor_ID
yes
no
 
CyCredDate
no
Company_ID
yes
no
 
 
 
Creditor_ID
yes
no
 
 
 
CInvoiceMovementPostDate
yes
no
 
CyCredYearPd
no
Company_ID
yes
no
 
 
 
Creditor_ID
yes
no
 
 
 
CInvoiceMovementYearPeriod
yes
no
 
CyDate
no
Company_ID
yes
no
 
 
 
CInvoiceMovementPostDate
yes
no
 
LastModIdx
no
LastModifiedDate
yes
no
 
Period
no
Period_ID
yes
no
 
PostingLine
no
PostingLine_ID
yes
no
 ∗
Prim
yes
CInvoiceMovement_ID
yes
no
 
UniqueIdx
yes
CInvoice_ID
yes
no
 
 
 
PostingLine_ID
yes
no
CInvoicePO
Supplier Invoice PO Matching Link
 
 
Field Name
Label
Col-Label
Format
Dec
 
CInvoice_ID
Link to CInvoice
 
-99999999999
 
 
CInvoicePO_ID
Record ID
 
-99999999999
 
 
CInvoicePOPoDomain
PO Domain
 
x(8)
 
 
CInvoicePOPoNbr
PO Number
 
x(8)
 
 
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
 
CInvoiceIdx
no
CInvoice_ID
yes
no
 
POIdx
no
CInvoicePOPoDomain
yes
no
 
 
 
CInvoicePOPoNbr
yes
no
 ∗
Prim
yes
CInvoicePO_ID
yes
no
CInvoicePosting
Supplier Invoice Posting Link
 
 
Field Name
Label
Col-Label
Format
Dec
 
CInvoice_ID
Link to CInvoice
 
-99999999999
 
 
CInvoicePosting_ID
Record ID
 
-99999999999
 
 
CInvoicePostingType
Invoice Type
Invoice Type
x(20)
 
 
CIRECPostingLine_ID
Link to PostingLine
 
-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)
 
 
Posting_ID
Link to Posting
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
CInvoice
no
CInvoice_ID
yes
no
 
CIRECPostLine
no
CIRECPostingLine_ID
yes
no
 
LastModIdx
no
LastModifiedDate
yes
no
 
Posting
no
Posting_ID
yes
no
 ∗
Prim
yes
CInvoicePosting_ID
yes
no
 
UniqueIdx
yes
CInvoice_ID
yes
no
 
 
 
Posting_ID
yes
no
CInvoiceStage
Supplier Invoice Stage Payment
 
 
Field Name
Label
Col-Label
Format
Dec
 
CInvoice_ID
Link to CInvoice
 
-99999999999
 
 
CInvoiceStage_ID
Record ID
 
-99999999999
 
 
CInvoiceStageAmountCC
SC Amount
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceStageAmountLC
BC Amount
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceStageAmountTC
TC Amount
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceStageAmtAppliedTC
TC Applied Amount
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceStageDiscDate
Discount Date
Disc Date
99/99/9999
 
 
CInvoiceStageDiscPerc
Discount Percentage
Disc Perc
->>9.99
3
 
CInvoiceStageDueDate
Due Date
 
99/99/9999
 
 
CInvoiceStagePercent
Percent
%
->,>>>,>>9.99
10
 
CInvoiceStageTSMNumber
Payment Reference
 
x(60)
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
PaymentConditionStaged_ID
Discount Percentage
Percent
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
CInvoice
no
CInvoice_ID
yes
no
 
DueDate
no
CInvoiceStageDueDate
yes
no
 
LastModIdx
no
LastModifiedDate
yes
no
 
PayCondStageIdx
no
PaymentConditionStaged_ID
yes
no
 ∗
Prim
yes
CInvoiceStage_ID
yes
no
 
UniqueIdx
yes
CInvoiceStageDueDate
yes
no
 
 
 
CInvoice_ID
yes
no
CInvoiceVat
Supplier Invoice Tax Records
 
 
Field Name
Label
Col-Label
Format
Dec
 
AbsRetTaxDivision_ID
Retained Tax Sub-Account
Retained Tax Sub-Acct
-99999999999
 
 
AbsRetTaxGL_ID
Retained Tax Account
 
-99999999999
 
 
CInvoice_ID
Link to CInvoice
 
-99999999999
 
 
CInvoiceVat_ID
Record ID
 
-99999999999
 
 
CInvoiceVatIsAbsRet
Retained
 
yes/no
 
 
CInvoiceVatIsAccrRcpUs
Accrue at Receipt/Usage
 
yes/no
 
 
CInvoiceVatIsRevCharge
Reverse Charge
Rev Charge
yes/no
 
 
CInvoiceVatIsSuspDel
Delayed Tax
Delay Tax
yes/no
 
 
CInvoiceVatIsTaxable
Taxable
 
yes/no
 
 
CInvoiceVatIsUpdAllow
Update Allow
Upd Allow
yes/no
 
 
CInvoiceVatNonRecTaxAmtTC
Non-Recoverable Tax Amount
Non-Rev Tax Amt
->>>,>>>,>>>,>>9.99
4
 
CInvoiceVatNTBaseCreditTC
TC Base Credit Non-taxable
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceVatNTBaseDebitTC
TC Base Debit Non-taxable
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceVatSequence
Sequence
 
9999999999
 
 
CInvoiceVatSuspDelTaxAmtTC
Tax Amount on Delayed Account (TC)
Tax Amount on Delay Acct (TC)
->>>,>>>,>>>,>>9.99
4
 
CInvoiceVatTaxTrType
Tax Transaction Type
 
x(2)
 
 
CInvoiceVatUILinkedRowID
Linked Row
 
x(30)
 
 
CInvoiceVatVatBaseCreditCC
SC Base Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceVatVatBaseCreditLC
BC Base Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceVatVatBaseCreditTC
TC Base Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceVatVatBaseDebitCC
SC Base Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceVatVatBaseDebitLC
BC Base Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceVatVatBaseDebitTC
TC Base Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceVatVatCreditCC
SC Tax Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceVatVatCreditLC
BC Tax Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceVatVatCreditTC
TC Tax Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceVatVatDebitCC
SC Tax Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceVatVatDebitLC
BC Tax Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceVatVatDebitTC
TC Tax Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CustomCombo0
Custom Combo Field
 
x(20)
 
 
CustomCombo1
Custom Combo Field
 
x(20)
 
 
CustomCombo2
Custom Combo Field
 
x(20)
 
 
CustomCombo3
Custom Combo Field
 
x(20)
 
 
CustomCombo4
Custom Combo Field
 
x(20)
 
 
CustomCombo5
Custom Combo Field
 
x(20)
 
 
CustomCombo6
Custom Combo Field
 
x(20)
 
 
CustomCombo7
Custom Combo Field
 
x(20)
 
 
CustomCombo8
Custom Combo Field
 
x(20)
 
 
CustomCombo9
Custom Combo Field
 
x(20)
 
 
CustomDate0
Custom Date Field
 
99/99/9999
 
 
CustomDate1
Custom Date Field
 
99/99/9999
 
 
CustomDate2
Custom Date Field
 
99/99/9999
 
 
CustomDate3
Custom Date Field
 
99/99/9999
 
 
CustomDate4
Custom Date Field
 
99/99/9999
 
 
CustomDecimal0
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal1
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal2
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal3
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal4
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomInteger0
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger1
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger2
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger3
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger4
Custom Integer Field
 
->,>>>,>>9
 
 
CustomLong0
Custom Long Field
 
x(255)
 
 
CustomLong1
Custom Long Field
 
x(255)
 
 
CustomNote
Custom Note Field
 
x(2000)
 
 
CustomShort0
Custom Short Field
 
x(20)
 
 
CustomShort1
Custom Short Field
 
x(20)
 
 
CustomShort2
Custom Short Field
 
x(20)
 
 
CustomShort3
Custom Short Field
 
x(20)
 
 
CustomShort4
Custom Short Field
 
x(20)
 
 
CustomShort5
Custom Short Field
 
x(20)
 
 
CustomShort6
Custom Short Field
 
x(20)
 
 
CustomShort7
Custom Short Field
 
x(20)
 
 
CustomShort8
Custom Short Field
 
x(20)
 
 
CustomShort9
Custom Short Field
 
x(20)
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
NormalTaxDivision_ID
Normal Tax Sub-Account
Normal Tax Sub-Acct
-99999999999
 
 
NormalTaxGL_ID
Normal Tax Account
 
-99999999999
 
 
PostingVat_ID
Link to PostingVat
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
SuspDelTaxDivision_ID
Delayed Tax Sub-Account
Delay Tax Sub-Acct
-99999999999
 
 
SuspDelTaxGL_ID
Delayed Tax Account
Delay Tax Acct
-99999999999
 
 
TxclTaxCls
Tax Class
 
x(3)
 
 
TxenvTaxEnv
Tax Environment
 
x(16)
 
 
TxtyTaxType
Tax Type
 
x(16)
 
 
TxuTaxUsage
Tax Usage
 
x(8)
 
 
Vat_ID
Domain
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
AbsRetDivIdx
no
AbsRetTaxDivision_ID
yes
no
 
AbsRetGLIdx
no
AbsRetTaxGL_ID
yes
no
 
CInvoice
no
CInvoice_ID
yes
no
 
NormalDivIdx
no
NormalTaxDivision_ID
yes
no
 
NormalGLIdx
no
NormalTaxGL_ID
yes
no
 
PostingVatIdx
no
PostingVat_ID
yes
no
 ∗
Prim
yes
CInvoiceVat_ID
yes
no
 
SuspDelDivIdx
no
SuspDelTaxDivision_ID
yes
no
 
SuspDelGLIdx
no
SuspDelTaxGL_ID
yes
no
 
UniqueTax
yes
CInvoice_ID
yes
no
 
 
 
TxuTaxUsage
yes
no
 
 
 
TxclTaxCls
yes
no
 
 
 
TxenvTaxEnv
yes
no
 
 
 
Vat_ID
yes
no
 
Vat
no
Vat_ID
yes
no
CInvoiceWHT
Supplier Invoice Withholding Tax
 
 
Field Name
Label
Col-Label
Format
Dec
 
CInvoice_ID
Link to CInvoice
 
-99999999999
 
 
CInvoiceVat_ID
Link To CInvoiceVat
 
-99999999999
 
 
CInvoiceWHT_ID
Record ID
 
-99999999999
 
 
CInvoiceWHTAmtCreditCC
SC WHT Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceWHTAmtCreditLC
BC WHT Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceWHTAmtCreditTC
TC WHT Amount (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceWHTAmtDebitCC
SC WHT Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceWHTAmtDebitLC
BC WHT Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceWHTAmtDebitTC
TC WHT Amount (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceWHTBaseTaxPct
Tax Base Percentage
 
->>9.99
2
 
CInvoiceWHTExpenseCreditTC
TC Expense (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceWHTExpenseDebitTC
TC Expense (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceWHTFeeCreditTC
TC Fee (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceWHTFeeDebitTC
TC Fee (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceWHTIsOrigFromAPM
Originated From Receiver Matching
 
yes/no
 
 
CInvoiceWHTIsUpdAllow
Update Tax Allowed
 
yes/no
 
 
CInvoiceWHTRecovTaxPct
Obsolete - Recoverable Tax Percentage
 
->>9.99
2
 
CInvoiceWHTTaxFeeCreditCC
SC Taxable Fee (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceWHTTaxFeeCreditLC
BC Taxable Fee (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceWHTTaxFeeCreditTC
TC Taxable Fee (CR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceWHTTaxFeeDebitCC
SC Taxable Fee (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceWHTTaxFeeDebitLC
BC Taxable Fee (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceWHTTaxFeeDebitTC
TC Taxable Fee (DR)
 
->>>,>>>,>>>,>>9.99
4
 
CInvoiceWHTTaxPct
Tax Percentage
 
->>9.99
2
 
CInvoiceWHTTaxTrType
Transaction Type
 
x(2)
 
 
CInvoiceWHTTaxType
Tax Type
 
x(20)
 
 
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)
 
 
Division_ID
Link to Division
 
-99999999999
 
 
GL_ID
Link to GL
 
-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)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
Vat_ID
Link to Vat
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
CInvoice
no
CInvoice_ID
yes
no
 
CInvoiceVat
no
CInvoiceVat_ID
yes
no
 
Division
no
Division_ID
yes
no
 
GL
no
GL_ID
yes
no
 ∗
Prim
yes
CInvoiceWHT_ID
yes
no
 
UniqueIdx
yes
CInvoice_ID
yes
no
 
 
 
CInvoiceVat_ID
yes
no
 
 
 
Vat_ID
yes
no
 
Vat
no
Vat_ID
yes
no
clc_ctrl
Compliance Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
clc__qadc01
 
 
x(8)
 
 
clc__qadi01
 
 
->>>>>>>9
 
 
clc_active
Compliance Active
Cmpl
yes/no
 
 
clc_comp_issue
Modify Component Issue
CmpIss
yes/no
 
 
clc_domain
Domain
 
x(8)
 
 
clc_jp_rcpt
Modify Co/By Product Receipts
CT
yes/no
 
 
clc_lotlevel
Lot Control Level
LCL
9
 
 
clc_polot_rcpt
Single Lot Per PO Receipt
Lot/PO
yes/no
 
 
clc_relot_rcpt
Single Lot per REPET Receipt
Lot/REP
yes/no
 
 
clc_user1
Ufld1
 
x(8)
 
 
clc_user2
Ufld2
 
x(8)
 
 
clc_wolot_rcpt
Single Lot per WO Receipt
Lot/WO
yes/no
 
 
oid_clc_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
clc_index1
yes
clc_domain
yes
no
 
oid_clc_ctrl
yes
oid_clc_ctrl
yes
no
ClientCache
client cache
 
 
Field Name
Label
Col-Label
Format
Dec
 
CacheKeyPart
Cache Key Part
 
x(255)
 
 
GUID
GUID
 
x(255)
 
 
Host
Host
 
x(255)
 
 
LastClearedDateUTC
Last Cleared Date
 
99/99/9999
 
 
LastClearedTimeUTC
Last Cleared Time
 
>>>>9
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
ClientCachePK
yes
CacheKeyPart
yes
no
clsf_mstr
Classification Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
clsf__qadc01
 
 
x(24)
 
 
clsf__qadc02
 
 
x(24)
 
 
clsf_classification
Classification
 
x(12)
 
 
clsf_desc
Description
 
x(24)
 
 
clsf_domain
Domain
 
x(8)
 
 
clsf_mod_date
Modified Date
Mod Date
99/99/99
 
 
clsf_mod_userid
User ID
 
x(8)
 
 
clsf_parent
Parent
 
x(12)
 
 
clsf_tree_key
Tree Key
 
x(180)
 
 
clsf_type
Type
 
x(8)
 
 
clsf_user1
User Field Character 1
 
x(24)
 
 
clsf_user2
User Field Character 2
 
x(24)
 
 
clsf_userd01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
clsf_useri01
User Field Integer 1
 
->>>>>>>9
 
 
clsf_userl01
User Field Logical 1
 
yes/no
 
 
clsf_usert01
User Field Date 1
 
99/99/99
 
 
oid_clsf_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
clsf_tree_key
yes
clsf_domain
yes
no
 
 
 
clsf_type
yes
no
 
 
 
clsf_tree_key
yes
no
clsf_type
yes
clsf_domain
yes
no
 
 
 
clsf_type
yes
no
 
 
 
clsf_classification
yes
no
 
oid_clsf_mstr
yes
oid_clsf_mstr
yes
no