|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CInvoice_ID
|
Link to CInvoice
|
|
9999999999
|
|
|
|
CInvoiceStage_ID
|
Record ID
|
|
9999999999
|
|
|
|
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
|
9999999999
|
|
|
|
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
|