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