In this article

CSV/XML Format: Deferral Schedule Data

The following tables provide information on the file formats for importing data. Every field is required to appear on the import file. However, not every field requires a value. In other words, the field column must appear in the file, but the value for the field in a row can be empty.

Tip: If you do not have a sample template and to ensure you have the latest format, execute the export action to save a file with the correct formatting.

Notes:

The following items provide information with respect to importing data: 

  • The header and line records can be combined into a single composite entity, which means it can be included in a single file. However, only XML files can be used with composite entities.
  • If a stubbing cutoff date exists, and the schedule details lines have a billing start date that is earlier than or the same as the stubbing cutoff date, the line is stubbed.
  • Each entity record is processed independently of all other entity records. As a result, when an import error occurs, only the line that has the error is rolled back. All other lines that are successfully imported are not affected.

    • For composite entities, the header and line are considered a single entity. If an import error occurs with the line, the header is not imported.

  • When price adjustment data is imported, the price adjustment line number is automatically generated.
  • When importing data, the ScheduleNumber is required. Also, the ScheduleLineNum is required for a billing schedule line, but optional for composite. For more information about the file format for the data, review the sample import file.

Straight Line Template

Review the following table for the required content for importing data to the SBS ARED Advanced Deferral Templates List page.

Select Copy to copy the sample to the clipboard.

Copy

AREDTemplateStraightHeader.txt sample

"5Y","one year","Monthly"

Select Copy to copy the sample to the clipboard.

Note icon. Note: Use the FireFox web browser when selecting Copy to ensure that the tab spaces in the code are copied correctly. With other web browsers, the tab spaces are copied as non-breaking spaces, which can cause the code to fail.

Copy

BssiAREDImportExportTemplate.xml sample

<?xml version="1.0" encoding="UTF-16" standalone="no"?>
<BSSIAREDImportExportTemplate>
    <HeaderInfo>
        <TemplateId>1Y</TemplateId>
        <TemplateDesc>one year</TemplateDesc>
        <BssiAredPeriodFrequency>Monthly</BssiAredPeriodFrequency>
        <LineInfo>
            <BssiAredPeriodType>Recognized</BssiAredPeriodType>
            <Length>12</Length>
        </LineInfo>
    </HeaderInfo>
    <HeaderInfo>
        <TemplateId>2Y</TemplateId>
        <TemplateDesc>two year</TemplateDesc>
        <BssiAredPeriodFrequency>Monthly</BssiAredPeriodFrequency>
        <LineInfo>
            <BssiAredPeriodType>Recognized</BssiAredPeriodType>
            <Length>24</Length>
            </LineInfo>
            <LineInfo>
            <BssiAredPeriodType> Skipped</BssiAredPeriodType>
            <Length>12</Length>
        </LineInfo>
    </HeaderInfo>
</BSSIAREDImportExportTemplate>

Select Copy to copy the sample to the clipboard.

Copy

AREDTemplateStraightLines.txt sample

"5Y","Recognized","48"
"5Y"," Skipped","12"

Event Based Template

Review the following table for the required content for importing data to the SBS ARED Event Based Deferral Templates List page.

Select Copy to copy the sample to the clipboard.

Copy

AREDTemplateEventBasedHeader.txt sample

"EVENT5","Event5"," By Percentage","No","10100"

Select Copy to copy the sample to the clipboard.

Copy

AREDTemplateEventBasedLines.txt sample

"EVENT5","eve1","20.00","0.00","0.00","No",""
"EVENT5","eve2","80.00","0.00","0.00","No",""

Select Copy to copy the sample to the clipboard.

Note icon. Note: Use the FireFox web browser when selecting Copy to ensure that the tab spaces in the code are copied correctly. With other web browsers, the tab spaces are copied as non-breaking spaces, which can cause the code to fail.

Copy

BssiAREDExpTmplEventtBased.xml sample

<?xml version="1.0" encoding="UTF-16" standalone="no"?>
<BSSIAREDImpExpTmpltEventBased>
    <HeaderInfo>
        <BssiAredTemplateId>EVE2</BssiAredTemplateId>
        <BssiAredTemplateDesc>eve2</BssiAredTemplateDesc>
        <BssiAredEventAllocationType> Variable Amounts</BssiAredEventAllocationType>
        <BssiAredEventPerUnit>No</BssiAredEventPerUnit>
        <BssiAredExpirationAccount>10200</BssiAredExpirationAccount>
        <LineInfo>
            <BssiAredEventDescription>eve1</BssiAredEventDescription>
            <BssiAredAllocationPercentage>0.00</BssiAredAllocationPercentage>
            <BssiAredComplelionPercentage>0.00</BssiAredComplelionPercentage>
            <ExpirationLength>0.00</ExpirationLength>
            <BssiAredRecognizeOnPost>No</BssiAredRecognizeOnPost>
            <BssiAredRecognitionAccount />
        </LineInfo>
        <LineInfo>
            <BssiAredEventDescription>eve2</BssiAredEventDescription>
            <BssiAredAllocationPercentage>0.00</BssiAredAllocationPercentage>
            <BssiAredComplelionPercentage>0.00</BssiAredComplelionPercentage>
            <ExpirationLength>0.00</ExpirationLength>
            <BssiAredRecognizeOnPost>No</BssiAredRecognizeOnPost>
            <BssiAredRecognitionAccount />
        </LineInfo>
    </HeaderInfo>
    
</BSSIAREDImpExpTmpltEventBased>
Column Name Data Type Required Description
Header      
BssiAredTemplateId String Required  
BssiAredTemplateDesc String    
BssiAredEventAllocationType String  

Options: 

  • Variable Amounts
  • Equal Amounts
  • By Percentage
  • Percentage of Completion
  • By Quantity
BssiAredEventPerUnit Enum   Yes/No
BssiAredExpirationAccount String    
Line      
BssiAredEventDescription String    
BssiAredAllocationPercentage Integer    
BssiAredComplelionPercentage Integer    
ExpirationLength Integer    
BssiAredRecognizeOnPost Enum   Yes/No
BssiAredRecognitionAccount String    

Deferrable Items

Select Copy to copy the sample to the clipboard.

Copy

AREDDefItems.txt sample

"Sales Invoice","Item","","Straight Line","1Y",""

Select Copy to copy the sample to the clipboard.

Note icon. Note: Use the FireFox web browser when selecting Copy to ensure that the tab spaces in the code are copied correctly. With other web browsers, the tab spaces are copied as non-breaking spaces, which can cause the code to fail.

Copy

BssiAREDImportDeferrableItems.txt sample

<?xml version="1.0" encoding="UTF-16" standalone="no"?>
<BSSIDeferrableItems>
    <DeferrableItems>
    <BSSIAREDTransectionType>Sales Invoice</BSSIAREDTransectionType>
    <ItemCode>Item</ItemCode>
    <ItemRelation>1896-S</ItemRelation>
    <DefaultTemplate>Straight Line</DefaultTemplate>
    <DefaultStraightLineTemplate>1Y</DefaultStraightLineTemplate>
    <DefaultEventBasedTemplate />
    </DeferrableItems>
</BSSIDeferrableItems>
Column Name Data Type Required Description
BSSIAREDTransactionType String    
ItemCode String    
ItemRelation String    
DefaultTemplate String    
DefaultStraightLineTemplate String    
DefaultEventBasedTemplate String    

Deferral Schedule

Select Copy to copy the sample to the clipboard.

Copy

AREDScheduleHeader.txt sample

"B0001","No","10100","Yes","Equal Amounts","No","Straight Line","1Y","","","No","40200","Debit","Standard Transcation","Active","Sales Line","Sales Invoice","","PS-INV103215","1896-S","10000","10300","10200","40300","50100","","","","","","No","No","No","ONE YEAR","10000","1,000.80","0.00","1,265.35","","","","0.00","0.00","0.00","",""
"B0002","No","10100","Yes","Equal Amounts","No","Straight Line","1Y","","","No","40200","Debit","Standard Transcation","Active","Sales Line","Sales Invoice","","PS-INV103215","1896-S","10000","10300","10200","40300","50100","","","","","","No","No","No","ONE YEAR","10000","1,000.80","0.00","1,265.35","","","","0.00","0.00","0.00","",""
"B0003","No","10100","Yes","Equal Amounts","No","Straight Line","1Y","","","No","40200","Debit","Standard Transcation","Active","Sales Line","Sales Invoice","","PS-INV103215","1896-S","10000","10300","10200","40300","50100","","","","","","No","No","No","ONE YEAR","10000","1,000.80","0.00","1,265.35","","","","0.00","0.00","0.00","",""
"B0004","No","10100","Yes","Equal Amounts","No","Straight Line","1Y","","","No","40200","Debit","Standard Transcation","Active","Sales Line","Sales Invoice","","PS-INV103216","1896-S","10000","10200","10300","40300","50100","","","","","","No","No","No","ONE YEAR","10000","1,000.80","0.00","1,072.47","","","","0.00","0.00","0.00","",""

Select Copy to copy the sample to the clipboard.

Copy

AREDScheduleLines.txt sample

"B0001","1","63.94","04/30/19","04/08/19","","","No","No","No","","","","0.00","0.00","Straight Line","0.00","80.84","","","","","",""
"B0001","2","83.40","05/31/19","05/01/19","","","No","No","No","","","","0.00","0.00","Straight Line","0.00","105.45","","","","","",""
"B0001","3","83.40","06/30/19","06/01/19","","","No","No","No","","","","0.00","0.00","Straight Line","0.00","105.45","","","","","",""
"B0001","4","83.40","07/31/19","07/01/19","","","No","No","No","","","","0.00","0.00","Straight Line","0.00","105.45","","","","","",""
"B0001","5","83.40","08/31/19","08/01/19","","","No","No","No","","","","0.00","0.00","Straight Line","0.00","105.45","","","","","",""
"B0002","1","63.94","04/30/19","04/08/19","","","No","No","No","","","","0.00","0.00","Straight Line","0.00","80.84","","","","","",""
"B0002","2","83.40","05/31/19","05/01/19","","","No","No","No","","","","0.00","0.00","Straight Line","0.00","105.45","","","","","",""
"B0002","3","83.40","06/30/19","06/01/19","","","No","No","No","","","","0.00","0.00","Straight Line","0.00","105.45","","","","","",""
"B0002","4","83.40","07/31/19","07/01/19","","","No","No","No","","","","0.00","0.00","Straight Line","0.00","105.45","","","","","",""
"B0002","5","83.40","08/31/19","08/01/19","","","No","No","No","","","","0.00","0.00","Straight Line","0.00","105.45","","","","","",""

Select Copy to copy the sample to the clipboard.

Note icon. Note: Use the FireFox web browser when selecting Copy to ensure that the tab spaces in the code are copied correctly. With other web browsers, the tab spaces are copied as non-breaking spaces, which can cause the code to fail.

Copy

BssiAREDImportSchedule.txt sample

<?xml version="1.0" encoding="UTF-16" standalone="no"?>
<BssiAredDeferralSchedule>
    <HeaderInfo>
        <ScheduleNo>B0001</ScheduleNo>
        <ConsolidatePriorPeriod>No</ConsolidatePriorPeriod>
        <DeferralAccount>10100</DeferralAccount>
        <EqualPerPeriod>Yes</EqualPerPeriod>
        <EventAllocationType>Equal Amounts</EventAllocationType>
        <EventPerUnit>No</EventPerUnit>
        <ScheduleType>Straight Line</ScheduleType>
        <EventTemplateID>1Y</EventTemplateID>
        <ExpirationAccount />
        <OnHoldAccount />
        <OnHoldTransferred>No</OnHoldTransferred>
        <RecognitionAccount>40200</RecognitionAccount>
        <RecognitionType>Debit</RecognitionType>
        <ScheduleCreationSource>Standard Transcation</ScheduleCreationSource>
        <ScheduleStatus>Active</ScheduleStatus>
        <SourceRecType>Sales Line</SourceRecType>
        <TransactionType>Sales Invoice</TransactionType>
        <Description />
        <SourceDocNo>PS-INV103215</SourceDocNo>
        <ItemNo>1896-S</ItemNo>
        <CustomerVendor>10000</CustomerVendor>
        <DiscountAccount>10300</DiscountAccount>
        <COGSAccount>10200</COGSAccount>
        <DiscRecogAccount>40300</DiscRecogAccount>
        <COGSRecogAccount>50100</COGSRecogAccount>
        <DiscOnHoldAccount />
        <COGSOnHoldAccount />
        <RevenueCancellationAcc />
        <DiscountCancellationAcc />
        <COGSCancellationAcc />
        <CancelUnrecogziedLine>No</CancelUnrecogziedLine>
        <CancelEntire>No</CancelEntire>
        <CancellationTransferred>No</CancellationTransferred>
        <EventTemplateIDName>ONE YEAR</EventTemplateIDName>
        <SourceLineNo>10000</SourceLineNo>
        <RevenueAmountFixed>1,000.80</RevenueAmountFixed>
        <DiscAmountFixed>0.00</DiscAmountFixed>
        <COGSAmountFixed>1,265.35</COGSAmountFixed>
        <STDeferralRevenueAct />
        <STDeferralDiscountAct />
        <STDeferralCogsAct />
        <STDeferralBalanceAmount>0.00</STDeferralBalanceAmount>
        <STDiscountBalanceAmount>0.00</STDiscountBalanceAmount>
        <STCOGSBalanceAmount>0.00</STCOGSBalanceAmount>
        <JournalTemplateName />
        <JournalTemplateBatch />
        <LineInfo>
            <LineNo>1</LineNo>
            <Amount>63.94</Amount>
            <DeferralEndDate>04/30/19</DeferralEndDate>
            <DeferralStartDate>04/08/19</DeferralStartDate>
            <EventDescription />
            <RecognitionAccount />
            <Recognized>No</Recognized>
            <RecognizeOnPost>No</RecognizeOnPost>
            <Stubbed>No</Stubbed>
            <ExpirationDate />
            <RecognitionLedgerJourn />
            <RecogntionDate />
            <AllocationPercentage>0.00</AllocationPercentage>
            <CompletionPercentage>0.00</CompletionPercentage>
            <ScheduleType>Straight Line</ScheduleType>
            <DiscountAmount>0.00</DiscountAmount>
            <COGSAmount>80.84</COGSAmount>
            <RecognitionJournalTemplate />
            <RecognitionJournalBatch />
            <ReverseRecogJnlTmplt />
            <ReverseRecogJnlBatch />
            <ReverseRecogJnlNo />
            <RevRecogntionDate />
        </LineInfo>
        <LineInfo>
            <LineNo>2</LineNo>
            <Amount>83.40</Amount>
            <DeferralEndDate>05/31/19</DeferralEndDate>
            <DeferralStartDate>05/01/19</DeferralStartDate>
            <EventDescription />
            <RecognitionAccount />
            <Recognized>No</Recognized>
            <RecognizeOnPost>No</RecognizeOnPost>
            <Stubbed>No</Stubbed>
            <ExpirationDate />
            <RecognitionLedgerJourn />
            <RecogntionDate />
            <AllocationPercentage>0.00</AllocationPercentage>
            <CompletionPercentage>0.00</CompletionPercentage>
            <ScheduleType>Straight Line</ScheduleType>
            <DiscountAmount>0.00</DiscountAmount>
            <COGSAmount>105.45</COGSAmount>
            <RecognitionJournalTemplate />
            <RecognitionJournalBatch />
            <ReverseRecogJnlTmplt />
            <ReverseRecogJnlBatch />
            <ReverseRecogJnlNo />
            <RevRecogntionDate />
        </LineInfo>
        <LineInfo>
            <LineNo>3</LineNo>
            <Amount>83.40</Amount>
            <DeferralEndDate>06/30/19</DeferralEndDate>
            <DeferralStartDate>06/01/19</DeferralStartDate>
            <EventDescription />
            <RecognitionAccount />
            <Recognized>No</Recognized>
            <RecognizeOnPost>No</RecognizeOnPost>
            <Stubbed>No</Stubbed>
            <ExpirationDate />
            <RecognitionLedgerJourn />
            <RecogntionDate />
            <AllocationPercentage>0.00</AllocationPercentage>
            <CompletionPercentage>0.00</CompletionPercentage>
            <ScheduleType>Straight Line</ScheduleType>
            <DiscountAmount>0.00</DiscountAmount>
            <COGSAmount>105.45</COGSAmount>
            <RecognitionJournalTemplate />
            <RecognitionJournalBatch />
            <ReverseRecogJnlTmplt />
            <ReverseRecogJnlBatch />
            <ReverseRecogJnlNo />
            <RevRecogntionDate />
        </LineInfo>
        <LineInfo>
            <LineNo>4</LineNo>
            <Amount>83.40</Amount>
            <DeferralEndDate>07/31/19</DeferralEndDate>
            <DeferralStartDate>07/01/19</DeferralStartDate>
            <EventDescription />
            <RecognitionAccount />
            <Recognized>No</Recognized>
            <RecognizeOnPost>No</RecognizeOnPost>
            <Stubbed>No</Stubbed>
            <ExpirationDate />
            <RecognitionLedgerJourn />
            <RecogntionDate />
            <AllocationPercentage>0.00</AllocationPercentage>
            <CompletionPercentage>0.00</CompletionPercentage>
            <ScheduleType>Straight Line</ScheduleType>
            <DiscountAmount>0.00</DiscountAmount>
            <COGSAmount>105.45</COGSAmount>
            <RecognitionJournalTemplate />
            <RecognitionJournalBatch />
            <ReverseRecogJnlTmplt />
            <ReverseRecogJnlBatch />
            <ReverseRecogJnlNo />
            <RevRecogntionDate />
        </LineInfo>
        <LineInfo>
            <LineNo>5</LineNo>
            <Amount>83.40</Amount>
            <DeferralEndDate>08/31/19</DeferralEndDate>
            <DeferralStartDate>08/01/19</DeferralStartDate>
            <EventDescription />
            <RecognitionAccount />
            <Recognized>No</Recognized>
            <RecognizeOnPost>No</RecognizeOnPost>
            <Stubbed>No</Stubbed>
            <ExpirationDate />
            <RecognitionLedgerJourn />
            <RecogntionDate />
            <AllocationPercentage>0.00</AllocationPercentage>
            <CompletionPercentage>0.00</CompletionPercentage>
            <ScheduleType>Straight Line</ScheduleType>
            <DiscountAmount>0.00</DiscountAmount>
            <COGSAmount>105.45</COGSAmount>
            <RecognitionJournalTemplate />
            <RecognitionJournalBatch />
            <ReverseRecogJnlTmplt />
            <ReverseRecogJnlBatch />
            <ReverseRecogJnlNo />
          <RevRecogntionDate />
        </LineInfo>
        <LineInfo>
            <LineNo>6</LineNo>
            <Amount>83.40</Amount>
            <DeferralEndDate>09/30/19</DeferralEndDate>
            <DeferralStartDate>09/01/19</DeferralStartDate>
            <EventDescription />
            <RecognitionAccount />
            <Recognized>No</Recognized>
            <RecognizeOnPost>No</RecognizeOnPost>
            <Stubbed>No</Stubbed>
            <ExpirationDate />
            <RecognitionLedgerJourn />
            <RecogntionDate />
            <AllocationPercentage>0.00</AllocationPercentage>
            <CompletionPercentage>0.00</CompletionPercentage>
            <ScheduleType>Straight Line</ScheduleType>
            <DiscountAmount>0.00</DiscountAmount>
            <COGSAmount>105.45</COGSAmount>
            <RecognitionJournalTemplate />
            <RecognitionJournalBatch />
            <ReverseRecogJnlTmplt />
            <ReverseRecogJnlBatch />
            <ReverseRecogJnlNo />
            <RevRecogntionDate />
        </LineInfo>
        <LineInfo>
            <LineNo>7</LineNo>
            <Amount>83.40</Amount>
            <DeferralEndDate>10/31/19</DeferralEndDate>
            <DeferralStartDate>10/01/19</DeferralStartDate>
            <EventDescription />
            <RecognitionAccount />
            <Recognized>No</Recognized>
            <RecognizeOnPost>No</RecognizeOnPost>
            <Stubbed>No</Stubbed>
            <ExpirationDate />
            <RecognitionLedgerJourn />
            <RecogntionDate />
            <AllocationPercentage>0.00</AllocationPercentage>
            <CompletionPercentage>0.00</CompletionPercentage>
            <ScheduleType>Straight Line</ScheduleType>
            <DiscountAmount>0.00</DiscountAmount>
            <COGSAmount>105.45</COGSAmount>
            <RecognitionJournalTemplate />
            <RecognitionJournalBatch />
            <ReverseRecogJnlTmplt />
            <ReverseRecogJnlBatch />
            <ReverseRecogJnlNo />
            <RevRecogntionDate />
        </LineInfo>
        <LineInfo>
            <LineNo>8</LineNo>
            <Amount>83.40</Amount>
            <DeferralEndDate>11/30/19</DeferralEndDate>
            <DeferralStartDate>11/01/19</DeferralStartDate>
            <EventDescription />
            <RecognitionAccount />
            <Recognized>No</Recognized>
            <RecognizeOnPost>No</RecognizeOnPost>
            <Stubbed>No</Stubbed>
            <ExpirationDate />
            <RecognitionLedgerJourn />
            <RecogntionDate />
            <AllocationPercentage>0.00</AllocationPercentage>
            <CompletionPercentage>0.00</CompletionPercentage>
            <ScheduleType>Straight Line</ScheduleType>
            <DiscountAmount>0.00</DiscountAmount>
            <COGSAmount>105.45</COGSAmount>
            <RecognitionJournalTemplate />
            <RecognitionJournalBatch />
            <ReverseRecogJnlTmplt />
            <ReverseRecogJnlBatch />
            <ReverseRecogJnlNo />
            <RevRecogntionDate />
        </LineInfo>
        <LineInfo>
            <LineNo>9</LineNo>
            <Amount>83.40</Amount>
            <DeferralEndDate>12/31/19</DeferralEndDate>
            <DeferralStartDate>12/01/19</DeferralStartDate>
            <EventDescription />
            <RecognitionAccount />
            <Recognized>No</Recognized>
            <RecognizeOnPost>No</RecognizeOnPost>
            <Stubbed>No</Stubbed>
            <ExpirationDate />
            <RecognitionLedgerJourn />
            <RecogntionDate />
            <AllocationPercentage>0.00</AllocationPercentage>
            <CompletionPercentage>0.00</CompletionPercentage>
            <ScheduleType>Straight Line</ScheduleType>
            <DiscountAmount>0.00</DiscountAmount>
            <COGSAmount>105.45</COGSAmount>
            <RecognitionJournalTemplate />
            <RecognitionJournalBatch />
            <ReverseRecogJnlTmplt />
            <ReverseRecogJnlBatch />
            <ReverseRecogJnlNo />
            <RevRecogntionDate />
        </LineInfo>
        <LineInfo>
            <LineNo>10</LineNo>
            <Amount>83.40</Amount>
            <DeferralEndDate>01/31/20</DeferralEndDate>
            <DeferralStartDate>01/01/20</DeferralStartDate>
            <EventDescription />
            <RecognitionAccount />
            <Recognized>No</Recognized>
            <RecognizeOnPost>No</RecognizeOnPost>
            <Stubbed>No</Stubbed>
            <ExpirationDate />
            <RecognitionLedgerJourn />
            <RecogntionDate />
            <AllocationPercentage>0.00</AllocationPercentage>
            <CompletionPercentage>0.00</CompletionPercentage>
            <ScheduleType>Straight Line</ScheduleType>
            <DiscountAmount>0.00</DiscountAmount>
            <COGSAmount>105.45</COGSAmount>
            <RecognitionJournalTemplate />
            <RecognitionJournalBatch />
            <ReverseRecogJnlTmplt />
            <ReverseRecogJnlBatch />
            <ReverseRecogJnlNo />
            <RevRecogntionDate />
        </LineInfo>
        <LineInfo>
            <LineNo>11</LineNo>
            <Amount>83.40</Amount>
            <DeferralEndDate>02/29/20</DeferralEndDate>
            <DeferralStartDate>02/01/20</DeferralStartDate>
            <EventDescription />
            <RecognitionAccount />
            <Recognized>No</Recognized>
            <RecognizeOnPost>No</RecognizeOnPost>
            <Stubbed>No</Stubbed>
            <ExpirationDate />
            <RecognitionLedgerJourn />
            <RecogntionDate />
            <AllocationPercentage>0.00</AllocationPercentage>
            <CompletionPercentage>0.00</CompletionPercentage>
            <ScheduleType>Straight Line</ScheduleType>
            <DiscountAmount>0.00</DiscountAmount>
            <COGSAmount>105.45</COGSAmount>
            <RecognitionJournalTemplate />
            <RecognitionJournalBatch />
            <ReverseRecogJnlTmplt />
            <ReverseRecogJnlBatch />
            <ReverseRecogJnlNo />
            <RevRecogntionDate />
        </LineInfo>
        <LineInfo>
            <LineNo>12</LineNo>
            <Amount>83.40</Amount>
            <DeferralEndDate>03/31/20</DeferralEndDate>
            <DeferralStartDate>03/01/20</DeferralStartDate>
            <EventDescription />
            <RecognitionAccount />
            <Recognized>No</Recognized>
            <RecognizeOnPost>No</RecognizeOnPost>
            <Stubbed>No</Stubbed>
            <ExpirationDate />
            <RecognitionLedgerJourn />
            <RecogntionDate />
            <AllocationPercentage>0.00</AllocationPercentage>
            <CompletionPercentage>0.00</CompletionPercentage>
            <ScheduleType>Straight Line</ScheduleType>
            <DiscountAmount>0.00</DiscountAmount>
            <COGSAmount>105.45</COGSAmount>
            <RecognitionJournalTemplate />
            <RecognitionJournalBatch />
            <ReverseRecogJnlTmplt />
            <ReverseRecogJnlBatch />
            <ReverseRecogJnlNo />
            <RevRecogntionDate />
        </LineInfo>
        <LineInfo>
            <LineNo>13</LineNo>
            <Amount>19.46</Amount>
            <DeferralEndDate>04/07/20</DeferralEndDate>
            <DeferralStartDate>04/01/20</DeferralStartDate>
            <EventDescription />
            <RecognitionAccount />
            <Recognized>No</Recognized>
            <RecognizeOnPost>No</RecognizeOnPost>
            <Stubbed>No</Stubbed>
            <ExpirationDate />
            <RecognitionLedgerJourn />
            <RecogntionDate />
            <AllocationPercentage>0.00</AllocationPercentage>
            <CompletionPercentage>0.00</CompletionPercentage>
            <ScheduleType>Straight Line</ScheduleType>
            <DiscountAmount>0.00</DiscountAmount>
            <COGSAmount>24.56</COGSAmount>
            <RecognitionJournalTemplate />
            <RecognitionJournalBatch />
            <ReverseRecogJnlTmplt />
            <ReverseRecogJnlBatch />
            <ReverseRecogJnlNo />
            <RevRecogntionDate />
        </LineInfo>
        </HeaderInfo>
</BssiAredDeferralSchedule>
Column Name Data Type Required Description
Header      
ScheduleNo String Required  
ConsolidatePriorPeriod Enum   Yes/No
DeferralAccount String    
EqualPerPeriod Enum   Yes/No
EventAllocationType String    
EventPerUnit Enum   Yes/No
ScheduleType String    
EventTemplateID String    
ExpirationAccount String    
OnHoldAccount String    
OnHoldTransferred Enum   Yes/No
RecognitionAccount String    
RecognitionType String    
ScheduleCreationSource String    
ScheduleStatus String    
SourceRecType String    
TransactionType String    
Description String    
SourceDocNo String    
ItemNo String    
CustomerVendor String    
DiscountAccount String    
COGSAccount String    
DiscRecogAccount String    
COGSRecogAccount String    
DiscOnHoldAccount String    
RevenueCancellationAcc String    
DiscountCancellationAcc String    
COGSCancellationAcc String    
CancelUnrecogziedLine Enum   Yes/No
CancelEntire Enum   Yes/No
CancellationTransferred Enum   Yes/No
EventTemplateIDName String    
SourceLineNo String    
RevenueAmountFixed Real    
DiscAmountFixed Real    
COGSAmountFixed Real    
STDeferralRevenueAct String    
STDeferralDiscountAct String    
STDeferralBalanceAmount Real    
STDiscountBalanceAmount Real    
STCOGSBalanceAmount Real    
JournalTemplateName String    
JournalTemplateBatch String    
Line Info      
Amount Real    
DeferralEndDate Date    
DeferralStartDate Date    
EventDescription String    
RecognitionAccount String    
Recognized Enum   Yes/No
RecognizeOnPost Enum   Yes/No
Stubbed Enum   Yes/No
ExpirationDate Date    
RecognitionLedgerJourn String    
RecogntionDate Date    
AllocationPercentage Real    
CompletionPercentage Real    
ScheduleType String    
DiscountAmount Real    
COGSAmount Real    
RecognitionJournalTemplate String    
RecognitionJournalBatch String    
ReverseRecogJnlTmplt String    
ReverseRecogJnlBatch String    
ReverseRecogJnlNo String    
RevRecogntionDate String