Resetting Field Values When Copying Invoices
When you run the copy bill or copy bill group processes, the system does not copy every field; it resets some fields to their starting values. This section lists the fields that the system does not copy and the reset values for those fields. Reset values in this table are the same regardless of whether you copy a single bill or group of bills.
Note: Some of the fields in these tables are used only by the system.
BI_HDR
|
Field Name |
Reset Value |
|---|---|
|
INVOICE |
New Invoice ID (invoice identification) |
|
INVOICE_TYPE |
"REG" (regular) |
|
CONSOL_HDR |
"N" (no) |
|
CONSOL_BUS_UNIT |
Blank |
|
CONSOL_INVOICE |
Blank |
|
ORIGINAL_INVOICE |
New Invoice ID |
|
PRIOR_ADJ_INVOICE |
Blank |
|
NEXT_ADJ_INVOICE |
Blank |
|
LATEST_INVOICE |
New Invoice ID |
|
ADJUSTED_FLAG |
"N" |
|
BILLING_FREQUENCY |
"ONC" (once) |
|
TEMPLATE_IVC_FLG |
"N" |
|
TEMPLATE_INVOICE |
Blank |
|
RECURRING_START_DT |
Null |
|
RECURRING_END_DT |
Null |
|
AUTO_GEN_IVC_NUM |
"N" |
|
FINAL_CURCNV_FLG |
"N" |
|
RATE_MULT |
If CUR_RT_SOURCE = U, then copy If CUR_RT_SOURCE = T = 0 |
|
RATE_DIV |
If CUR_RT_SOURCE = U, then copy If CUR_RT_SOURCE = T = 1 |
|
RATE_MULT_XEU |
"0" |
|
RATE_DIV_XEU |
"1" |
|
RATE_MULT_IU |
"0" |
|
RATE_DIV_IU |
"1" |
|
RATE_DATE |
Null |
|
PAID_AMT_BSE |
"0.00" |
|
FORWARD_BAL_BSE |
"0.00" |
|
INVOICE_PRETAX_BSE |
"0.00" |
|
INVOICE_AMT_BSE |
"0.00" |
|
FORWARD_BAL_XEU |
"0.00" |
|
INVOICE_PRETAX_XEU |
"0.00" |
|
INVOICE_AMT_XEU |
"0.00" |
|
PAID_AMT_XEU |
"0.00" |
|
INVOICE_DT |
Null |
|
ACCOUNTING_DT |
Null |
|
DT_INVOICED |
Null |
|
DUE_DT |
Null |
|
IVC_PRINTED_FLG |
"N" |
|
IVC_PRINTED_DT |
Null |
|
EDI_SENT_FLG |
"N" |
|
AR_ENTRY_CREATED |
"N" |
|
GL_ENTRY_CREATED |
"N" |
|
PRELOAD_IND |
"1" (pending) |
|
BILL_STATUS |
"New" |
|
BILL_STATUS_TEXT |
"Bill created via online Bill Copy function." |
|
LAST_LINE_AAUX_SEQ |
"0" |
|
DOC_SEQ_NBR |
Blank |
|
DOC_SEQ_DATE |
Null |
|
DIRECT_INVOICING |
"N" |
|
RANGE_SELECTION_ID |
Blank |
|
GEN_AP_VCHR_FLG |
"U" (undefined) |
|
AP_CREATED_DT |
Null |
|
DOC_SEQ_STATUS |
Blank |
|
EARLY_PY_DSCNT_PCT |
"0" |
|
DS_PY_TRMS_TIME_ID |
Blank |
|
TOT_SU_TAX |
"0.00" |
|
TOT_SU_TAX_BSE |
"0.00" |
|
TOT_SU_TAX_XEU |
"0.00" |
|
TOT_VAT |
"0.00" |
|
TOT_VAT_BSE |
"0.00" |
|
TOT_VAT_XEU |
"0.00" |
|
TOT_VAT_BASIS |
"0.00" |
|
TOT_VAT_BASIS_BSE |
"0.00" |
|
TOT_VAT_BASIS_XEU |
"0.00" |
|
USER_AMT1_BSE |
"0.00" |
|
USER_AMT2_BSE |
"0.00" |
|
USER_AMT1_XEU |
"0.00" |
|
USER_AMT2_XEU |
"0.00" |
|
PROCESS_INSTANCE |
"0" |
|
ADD_DTTM |
Current Date |
|
LAST_UPDATE_DTTM |
Current Date |
|
LAST_MAINT_OPRID |
User ID |
|
PAID_REFERENCE |
Blank |
|
IVC_DELIVERED_FLG |
"N" (No) |
|
AG_REF_NBR |
"0" |
|
IVC_DELIVERED_DT |
Null |
|
BI_PAID_AT_SRC |
"0" |
|
BI_APPROVAL_STATUS |
"0" or "1" |
HDR_VAT
|
Field Name |
Reset Value |
|---|---|
|
INVOICE |
New Invoice ID |
|
VAT_DCLRTN_DT |
Null |
HDR_AR, LINE_DS_DFR
|
Field Name |
Reset Value |
|---|---|
|
INVOICE |
New Invoice ID |
|
ADD_DTTM |
Current Date |
|
LAST_UPDATE_DTTM |
Current Date |
|
LAST_MAINT_OPRID |
User ID |
BI_LINE
|
Field Name |
Reset Value |
|---|---|
|
INVOICE |
New Invoice ID |
|
INVOICE_LINE |
"0" |
|
ORIGINAL_INVOICE |
New Invoice ID |
|
ORIGINAL_LINE_SEQ |
LINE_SEQ_NUM |
|
NEXT_ADJ_INVOICE |
Blank |
|
NEXT_ADJ_LINE_SEQ |
"0" |
|
PRIOR_ADJ_INVOICE |
Blank |
|
PRIOR_ADJ_LINE_SEQ |
"0" |
|
LATEST_INVOICE |
New Invoice ID |
|
LATEST_LINE_SEQ |
LINE_SEQ_NUM |
|
ADJ_LINE_TYPE |
"REG" |
|
ADJUSTED_FLAG |
"N" |
|
GROSS_EXTENDED_BSE |
"0.00" |
|
NET_EXTENDED_BSE |
"0.00" |
|
GROSS_EXTENDED_XEU |
"0.00" |
|
NET_EXTENDED_XEU |
"0.00" |
|
ORIG_AMOUNT |
"0.00" |
|
ORIG_QTY |
"0.00" |
|
TAX_AMT |
"0.00" |
|
TAX_AMT_BSE |
"0.00" |
|
TAX_AMT_XEU |
"0.00" |
|
TAX_PCT |
"0.00" |
|
FINAL_TAX_FLG |
"N" |
|
VAT_BASIS_AMT_BSE |
"0.00" |
|
VAT_BASIS_AMT_XEU |
"0.00" |
|
VAT_AMT_BSE |
"0.00" |
|
VAT_AMT_XEU |
"0.00" |
|
VAT_DISTRIB_STATUS |
"U" |
|
DEFERRED_STATUS |
"N" |
|
ACCRUE_DT |
Null |
|
TOT_LINE_DST_BSE |
"0.00" |
|
TOT_LINE_DFR_BSE |
"0.00" |
|
TOT_LINE_DST_XEU |
"0.00" |
|
TOT_LINE_DFR_XEU |
"0.00" |
|
TOT_DISCOUNT_BSE |
"0.00" |
|
TOT_SURCHARGE_BSE |
"0.00" |
|
TOT_DISCOUNT_XEU |
"0.00" |
|
TOT_SURCHARGE_XEU |
"0.00" |
|
USER_AMT1_BSE |
"0.00" |
|
USER_AMT2_BSE |
"0.00" |
|
USER_AMT1_XEU |
"0.00" |
|
USER_AMT2_XEU |
"0.00" |
|
PROCESS_INSTANCE |
"0" |
|
ADD_DTTM |
Current Date |
|
LAST_UPDATE_DTTM |
Current Date |
|
LAST_MAINT_OPRID |
User ID |
|
CUST_DEPOSIT_ID |
Blank |
BI_HDR_CC, BI_HDR_NOTE, BI_LINE_NOTE, BI_LINE_TAX
|
Field Name |
Reset Value |
|---|---|
|
INVOICE |
New Invoice ID |
|
ADD_DTTM |
Current Dt (current date) |
|
LAST_UPDATE_DTTM |
Current Date |
|
LAST_MAINT_OPRID |
User ID |
|
IVC_DELIVERED_FLG |
"N" (No) Note: BI_HDR_CC only. |
|
IVC_DELIVERED_DT |
Null Note: BI_HDR_CC only. |
LINE_DS_LVL
|
Field Name |
Reset Value |
|---|---|
|
INVOICE |
New Invoice ID |
|
LVL_SUBTOTAL_BSE |
"0.00" |
|
TOTAL_LVL_DISC_BSE |
"0.00" |
|
TOTAL_LVL_SUR_BSE |
"0.00" |
|
LVL_SUBTOTAL_XEU |
"0.00" |
|
TOTAL_LVL_DISC_XEU |
"0.00" |
|
TOTAL_LVL_SUR_XEU |
"0.00" |
|
ADD_DTTM |
Current Date |
|
LAST_UPDATE_DTTM |
Current Date |
|
LAST_MAINT_OPRID |
User ID |
HDR_CRCARD, LINE_DST, LINE_DST_AR, LINE_DST_DFR, LINE_DST_DTL, LINE_IU_EXP, LINE_IU_PAY
|
Field Name |
Reset Value |
|---|---|
|
INVOICE |
New Invoice ID |
|
AMOUNT_BSE |
"0.00" |
|
AMOUNT_XEU |
"0.00" |
|
INSTALLMENT_DS_AMT |
"0.00" |
|
INSTALLMENT_DS_BSE |
"0.00" |
|
INSTALLMENT_DS_XEU |
"0.00" |
|
ADD_DTTM |
Current Date |
|
LAST_UPDATE_DTTM |
Current Date |
|
LAST_MAINT_OPRID |
User ID |